Showing posts with label Select User From Table. Show all posts
Showing posts with label Select User From Table. Show all posts

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