从存储过程获取返回值 [英] Getting return value from stored procedure

问题描述

我有以下存储过程：

I have the following stored procedure:

ALTER PROCEDURE spLogin
       @CAD_WEB_LOGIN_USERNAME varchar(60),
       @CAD_WEB_LOGIN_PASSWORD varchar(60),
       @Result int output
AS
BEGIN
    SELECT @Result=CAD_NUMBER
     FROM   CMACADDR
     WHERE  CAD_WEB_LOGIN_USERNAME = @CAD_WEB_LOGIN_USERNAME
            AND CAD_WEB_LOGIN_PASSWORD = @CAD_WEB_LOGIN_PASSWORD

     RETURN @Result -- return value

END

注意：它返回Null值

这个存储过程的逻辑是什么

谢谢

Note: It's Returning Null value
What's the logic for this Stored Procedure
Thanks

推荐答案

ALTER PROCEDURE spLogin
@CAD_WEB_LOGIN_USERNAME varchar(60),
@CAD_WEB_LOGIN_PASSWORD varchar(60)
AS
BEGIN
DECLARE @Result INT
SET @Result=0
IF EXISTS(SELECT CAD_NUMBER FROM  CMACADDR 
WHERE CAD_WEB_LOGIN_USERNAME = @CAD_WEB_LOGIN_USERNAME
AND CAD_WEB_LOGIN_PASSWORD = @CAD_WEB_LOGIN_PASSWORD)
BEGIN
	SET @Result=(SELECT ISNULL(CAD_NUMBER,0)
	FROM CMACADDR
	WHERE CAD_WEB_LOGIN_USERNAME = @CAD_WEB_LOGIN_USERNAME
	AND CAD_WEB_LOGIN_PASSWORD = @CAD_WEB_LOGIN_PASSWORD)
END 

RETURN @Result -- return value

如果返回0表示不匹配，则为您提供CAD_NUMBER

If returns 0 means no match else give you CAD_NUMBER

读取此 stackoverflow [ ^ ]问题第一个答案应该有助于您了解如何操作

Have a read of this stackoverflow [^] question the first answer should help you understand how to do it

Quote：

此存储过程的逻辑是什么

What's the logic for this Stored Procedure

SELECT 查询返回 NULL 基于登录UserName&的值密码（表示该用户没有匹配的记录）。



如果你不想 NULL 那么你可以将其转换为空字符串。

The SELECT query returns the NULL value based on logon UserName & Password(that means no matching records for that user).

If you don't want NULL then you could convert that to blank string.

这篇关于从存储过程获取返回值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！