Thursday, August 4, 2011

Stored Procedure To Select User From Table

Alter proc selectuser
@uname nvarchar(max),
@pas nvarchar(max)

as

select count(*) as count1 from ulogin where username=@uname and password=@pas

return


Execute SP


Execute selectuser @uname=k,@pas=124

No comments:

Post a Comment