Username and Password verification in SQL stored procedure.


Goals:

This stored procedure is used to verify username and password itself.

Steps:

1) Create a stored procedure.

2) copy the following code.

CREATE PROCEDURE [trainee].[empinfologin]
(@username varchar(20), @password varchar(20), @values int output)
AS
declare @user varchar(20)
declare @pass varchar(20)
declare @result varchar(40)

BEGIN
select @user=username, @pass=password from empinfo
where username=@username and password=@password
if @user = @username and @pass = @password
begin
set @result='Success'
set @values=1
return @values
end
else
begin
select @user=username, @pass=password from empinfo where
username=@username
if @user=@username and @pass!=@password
begin
set @result='Incorrect Password'
set @values=2
return @values
end
else
SET @result='User does not exist'
set @values=3
return @values
end
END