T-SQL 中的 CALL 和 EXEC 有什么区别?

2021-09-10 00:00:00 sql tsql sql-server-2008 sql-server

考虑:

CREATE PROCEDURE LowerCityDiscounts @city VARCHAR(45), @decrease DECIMAL(10,2) AS
BEGIN
    BEGIN TRANSACTION;
    UPDATE Customers SET discnt = discnt - @decrease
    WHERE Customers.city = @city;

    UPDATE Customers SET discnt = 0
    WHERE Customers.city = @city AND discnt < 0
    COMMIT;
END;

我尝试使用以下方法调用此过程:

I tried to call this procedure with:

CALL LowerCityDiscounts 'Cleveland', 5;

但这只会产生

Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'Cleveland'.

然而，如果我把事情改成

Yet, if I change things to

EXEC LowerCityDiscounts 'Cleveland', 5;

一切正常.尽管文档指出call是正确的语法.

everything works fine. This despite that the documentation stating that call is the right syntax.

为什么 EXEC 起作用而 CALL 不起作用?

Why does EXEC work when CALL does not?

推荐答案

是的.. CALL 是可从 ODBC 驱动程序使用的构造/语法，如您的文档所示.

Yup.. CALL is an construct/syntax usable from an ODBC driver, as your documentation indicates.

T-SQL 文档中没有对 CALL 的引用，只有 EXEC.

There's no reference in the T-SQL documentation to CALL, only EXEC.

它不起作用，因为它不是 T-SQL.

It doesn't work because it's not T-SQL.

相关文章