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

by

[ad_1]

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

[ad_2]

solved Getting error in stored procedure for checkUser for login