[Solved] Getting error in stored procedure for checkUser for login

by


Use it as 

Declare @num int 

Set @num =1  

SELECT * FROM USERLOGIN 
WHERE USERNAME=@username AND PWD=@PWD 
AND level = @num

if you are using SQL server below 2008

or like 

Declare @num int=1

SELECT * FROM USERLOGIN 
WHERE USERNAME=@username AND PWD=@PWD 
AND level = @num

for SQL Server 2008 and above

0

solved Getting error in stored procedure for checkUser for login