User valid or none valid procedure in SQL Server

create database zz
-create table
create table users (id int identity(1,1),username varchar(50),password
varchar(50))
--insert values in table
insert into users values('kul',123)
--create procedure
create proc getoutput
(
@UserName varchar(50),
@password varchar(50),
@UName varchar(50) OUTPUT,
@Pword varchar(50) OUTPUT
)
as
Begin
IF EXISTS(Select * FROM users WHERE UserName = @UserName AND Password = @password)
Begin
set @UName=@UserName
set @Pword=@password
end
else
begin
print 'You are not a valid user.'
end
End
--call procedure
declare @UsName varchar(50);
declare @pass varchar(50);
exec getoutput 'kul','1223' ,@UName=@UsName output,@Pword=@pass output
print @UsName
print @pass

        

Share: