SP return always 0 value

Question

i am trying develop login page , in that calling SP for validate the records , but it return always 0 .   please find the SP code here   CREATE PROCEDURE [DBO].[SP_LOGIN] @USERNAME VARCHAR(50), @PASSWORD VARCHAR(50), @RESULT VARCHAR(50) OUT AS BEGIN SET NOCOUNT ON; SELECT count(*) FROM TBL_USERDETAILS WHERE USERNAME = '@USERNAME' AND PASSWORD = '@PASSWORD' RETURN END   Please give me proper solution

Pankaj Kumar Choudhary · Answer

Hello @Srinivasulu there is a little mistake your are using  USERNAME='@USERNAME' this is not proper way. in this case  system '@USERNAME' treat as a string not as a variable   use this CREATE PROCEDURE [DBO].[SP_LOGIN] @USERNAME VARCHAR(50), @PASSWORD VARCHAR(50), @RESULT VARCHAR(50) OUT AS BEGIN SET NOCOUNT ON; SELECT count(*) FROM TBL_USERDETAILS WHERE USERNAME = @USERNAME AND PASSWORD = @PASSWORD RETURN END

Vignesh Mani · Answer

Hi,   I validation correct assign return value 1. other wise return value 0. You should assign value before return.

Manas Mohapatra · Answer

Hi Srini,   You are getting 0 always return value due to following reason:   You are using  @Result as output parameter but not assigning anywhere inside SP. Secondly single qoute(' ') is used in parameters when fetching rows. Please find updated code:    Code:     ALTER PROCEDURE [DBO].[SP_LOGIN]    @USERNAME VARCHAR(50),    @PASSWORD VARCHAR(50),    @RESULT VARCHAR(50) OUT AS BEGIN    SET NOCOUNT ON;      SELECT @RESULT = COUNT(*) FROM  TBL_USERDETAILS    WHERE USERNAME = @USERNAME AND PASSWORD = @PASSWORD;      RETURN @RESULT; END

Ankit Shukla · Answer

Hi,      Try this:     SELECT count(*) FROM TBL_USERDETAILS WHERE USERNAME = @USERNAME AND PASSWORD = @PASSWORD

Rajeesh Menoth · Answer

Hi,   Ref this : http://stackoverflow.com/questions/6034746/is-a-return-value-of-0-always-a-success-in-stored-procedures