22,209
社区成员
发帖
与我相关
我的任务
分享
Create PROCEDURE[dbo].[sp_Accounts_ValidateLogin] (
@EmailAddress varchar(255),
@Password varchar(20) ) AS
DECLARE @UserID int
SELECT @UserID = UserID
FROM Accounts_Users
WHERE EmailAddress =@EmailAddress and Password =@Password
IF @UserID !=NULL
RETURN @UserID
ELSE
RETURN -1