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
Posts
