我们如何使用return关键字从sql存储过程中返回值 [英] how we return value from sql stored procedure using return keyword

问题描述

我们如何使用return关键字从sql存储过程中返回值?

how we return value from sql stored procedure using return keyword?

推荐答案

如此处所述
http://msdn.microsoft.com/en-us/library/ms174998.aspx [ ^ ]
RETURN语句无条件地从 query or procedure. RETURN is immediate 退出，并且可以完全退出，并且可以在任何时候用于从过程，批处理或语句块中退出.不执行RETURN之后的语句.

As explained here
http://msdn.microsoft.com/en-us/library/ms174998.aspx[^]
RETURN statement exits unconditionally from a query or procedure. RETURN is immediate and complete and can be used at any point to exit from a procedure, batch, or statement block. Statements that follow RETURN are not executed.

例如

CREATE PROCEDURE Test AS
BEGIN
   RETURN 1;
END;

有关示例和说明，请参考返回 [

For example and explanations, please refer to RETURN [^]

CREATE PROCEDURE Test AS
BEGIN
   RETURN 1;
END;

这篇关于我们如何使用return关键字从sql存储过程中返回值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！