스토어프로시저 질문

ALTER PROCEDURE [dbo].[spLogin]

@accountid text,

@password text,

@ret int OUTPUT

AS 

DECLARE @userIdCount int;

SELECT @userIdCount = COUNT(*) 

FROM [dbo].[Accounts] 

WHERE  account like @accountid;

if (@userIdCount = 0)

BEGIN

SELECT @ret = 0;

END

else

BEGIN

DECLARE @LOGIN_OK int = 1;

DECLARE @LOGIN_ID_FAILED int = 2;

DECLARE @LOGIN_LOGGEDIN int = 3;

DECLARE @checkCount int;

DECLARE @loggedin tinyint;

SELECT @checkCount = COUNT(*)

FROM [dbo].[Accounts] 

WHERE  account like @accountid AND password like @password;

SELECT @loggedin = loggedin

FROM [dbo].[Accounts] 

WHERE  account like @accountid AND password like @password;

if (@checkCount > 0)

BEGIN

if (@loggedin > 0)

BEGIN

SELECT @ret = @LOGIN_LOGGEDIN;

END

else

BEGIN

SELECT @ret = @LOGIN_OK;

UPDATE [dbo].[Accounts] SET loggedin = 1 WHERE account like @accountid; --이곳이 실행되면 output값을 코드에서 받지못함.

END

END

else

BEGIN

SELECT @ret = @LOGIN_ID_FAILED;

END

END

RETURN @ret