I actually wants to return an integer value from my SP.
My SP is something like this:
Create procedure LOGINUSER ( @USERNAME VARCHAR(200), @PASSWORD VARCHAR(200), @LOGINFLAG INT OUTPUT ) AS SELECT * FROM Users WHERE Username=@USERNAME AND Password=@PASSWORD
GO
** this select statement should return ant integer value in my output parameter @LOGINFLAG.
this int variable i'll use in my asp code to check for the valid login.. Please help!!!
I actually wants to return an integer value from my SP.
My SP is something like this:
Create procedure LOGINUSER ( @USERNAME VARCHAR(200), @PASSWORD VARCHAR(200), @LOGINFLAG INT OUTPUT ) AS SELECT * FROM Users WHERE Username=@USERNAME AND Password=@PASSWORD
GO
** this select statement should return ant integer value in my output parameter @LOGINFLAG.
this int variable i'll use in my asp code to check for the valid login.. Please help!!!
if its integer value you can also use RETURN statement to return status from procedure
Output parameter return from Stored Prodeure
Posted - 06/08/2012 : 02:19:00
