我正在尝试编写一个过程,该过程将在成员列表中搜索输入了用户名和密码的匹配成员。如果找到匹配项,则应输出1。
这是我的代码:
CREATE PROC LoginProcedure
@email varchar(50),
@password varchar(50),
@found bit output
AS
IF(EXISTS(SELECT *
FROM Members
WHERE email = @email AND password = @password))
BEGIN
@found = 1; ---HERE
END
ELSE
BEGIN
@found = 0; ----HERE
END
GO ---HERE
我在出现错误的所有行旁都发表了评论。该错误在所有3行中都相同。
语法错误
SQL Server使用set
或select
分配值:
CREATE PROCEDURE LoginProcedure (
@email varchar(50),
@password varchar(50),
@found bit output
)
AS BEGIN
IF (EXISTS (SELECT * FROM Members where email = @email and password = @password
))
BEGIN
SET @found = 1; ---HERE
END;
ELSE BEGIN
SELECT @found = 0; ----HERE
END;
END; -- LoginProcedure
我认为将其编写为case
语句会更简单:
BEGIN
SET @found = (CASE WHEN EXISTS (SELECT * FROM Members where email = @email and password = @password)
THEN 1 ELSE 0
END);
END;
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句