sql - 删除...输出计数(已删除。*)

Question

我想知道在某个 DELETE 操作中删除了多少行。

我拿了 the Microsoft example B这是

DELETE Sales.ShoppingCartItem
OUTPUT DELETED.* 
WHERE ShoppingCartID = 20621;

并尝试修改它以仅返回 count删除的记录:

DELETE FROM datacache 
OUTPUT COUNT(DELETED.*)
WHERE userId=@id

但这会抛出

ExceptionMessage: "Incorrect syntax near '*'."
ExceptionType: "System.Data.SqlClient.SqlException"
Message: "Error"

所以我试过了

DELETE FROM datacache 
OUTPUT COUNT(DELETED)
WHERE userId=@id

哪个抛出

ExceptionMessage: "Invalid column name 'DELETED'."
ExceptionType: "System.Data.SqlClient.SqlException"
Message: "Error"

我错过了什么？

Answer 1

只需运行您的查询并获取修改后的行

DELETE 
FROM datacache 
WHERE userId=@id

SELECT @@ROWCOUNT