SQL Server Output $action in a INSERT statement

gk7wooem 于 2023-04-04 发布在其他

关注(0)|答案(1)|浏览(125)

How do I output $action here for "INSERT"?

DECLARE @OutputTbl TABLE (Id int, FirstName nvarchar(50), City nvarchar(50))

INSERT @OutputTbl (Id, FirstName, City)
OUTPUT $ACTION
VALUES
(1,'John','Jackson')

SELECT * FROM @OutputTbl

Msg 207, Level 16, State 1, Line 4 Invalid column name '$ACTION'.

Completion time: 2023-03-29T14:51:33.7353021-04:00

sql-server

来源：https://stackoverflow.com/questions/75881280/output-action-in-a-insert-statement

1条答案

按热度按时间

mi7gmzs61#

As Dale K has mentioned, and as stated in the documentation , $action is specific to MERGE as a MERGE can INSERT , UPDATEandDELETE .
$action
Is available only for the MERGE statement. Specifies a column of type nvarchar(10) in the OUTPUT clause in a MERGE statement that returns one of three values for each row: 'INSERT', 'UPDATE', or 'DELETE', according to the action that was performed on that row.

On the other hand, an INSERT can only do one thing; INSERT . So, just return that as a literal as you know what the action is:

DECLARE @OutputTbl TABLE (Id int,
                          FirstName nvarchar(50),
                          City nvarchar(50));

INSERT @OutputTbl (Id, FirstName, City)
OUTPUT N'INSERT'
VALUES (1,'John','Jackson');

SELECT *
FROM @OutputTbl;

赞(0）回复(0）举报 2023-04-04

我来回答

SQL Server Output $action in a INSERT statement

1条答案

相关问题

热门标签

最新问答