存储过程中的返回值问题
存储过程中的RETURN值在代码中如何接收?
exists的值怎么来的?
ALTER PROCEDURE HR_Personnel_Login
(
@UserID varchar(50),
@Password varchar(50)
)
AS
if exists
(
SELECT USRID
FROM HR_PersonnelInfo
WHERE USRID = @UserID
AND UsrPassword = @Password
)
RETURN 0
if exists
(
SELECT USRID
FROM HR_PersonnelInfo
WHERE USRID = @UserID
)
RETURN 1
RETURN 2