简单登录用存储过程

-- 用户登陆验证是否存在此用户名 , 不存在返回 , 密码错误返回 , 正确返回 , 并把 GUID 返回

 

ALTER PROC [dbo].[user_SignIn]

 

       @Email NVARCHAR(200),

 

       @Password NVARCHAR(100),

 

       @UserGUID UNIQUEIDENTIFIER OUTPUT,

 

       @OutputState INT OUTPUT

 

AS

 

       --SELECT Email FROM user_Users WHERE Email

 

 

       --Declare @Email NVARCHAR(200)

 

       --SET @Email = 'Jason@hotmail.com'

 

BEGIN TRANSACTION

 

       IF NOT EXISTS(SELECT Email FROM user_Users WHERE Email = @Email)

 

              BEGIN

 

                     SET @OutputState = 0

 

                     --RETURN

 

              END

 

              ELSE

 

                     IF NOT EXISTS(SELECT Password FROM user_Users WHERE Password = @Password

 

                     AND Email = @Email)

 

                     BEGIN

 

                            SET @OutputState = 1

 

                            --RETURN

 

                     END

 

       ELSE

 

       BEGIN

 

              SET @OutputState = 2

 

              SELECT @UserGUID = GUID FROM user_Users WHERE Email = @Email AND Password = @Password

 

       END

 

IF @@ERROR = 0

 

       BEGIN

 

              COMMIT TRANSACTION

 

       END

 

ELSE

 

       BEGIN

 

              ROLLBACK TRANSACTION

 

       END