Store Procedure For Forgot Password

USE [ITS_Trainees]
GO
/****** Object:  StoredProcedure [dbo].[VendorForgotPassword]    Script Date: 02/01/2011 15:16:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[VendorForgotPassword]
(
@UserName As nvarchar(50)
)
AS
Begin

     SELECT COUNT(*) FROM hbnVendorReg
WHERE UserName=@UserName
IF(@@rowcount = 0)
begin
RAISERROR('UserName does not exists',16,1);
end;
else
 begin
 SELECT r.Password  FROM hbnVendorReg r
 WHERE UserName=@UserName;
 end;


END

Posted in: SQL