SQL Server - @@ROWCOUNT, @@IDENTITY

阅读目录(Content)

• @@ROWCOUNT Get affected rows when do UPDATE / DELETE / INSERT
• @@IDENTITY

回到顶部(go to top)

@@ROWCOUNT Get affected rows when do UPDATE / DELETE / INSERT

Note that:
@@ROWCOUNT is reset after every statement so you must retrieve the value immediately with no intervening statements.

Pasted from <https://stackoverflow.com/questions/8577632/how-can-i-get-number-of-deleted-records>

 

 

回到顶部(go to top)

@@IDENTITY

After an INSERT, SELECT INTO, or bulk copy statement is completed, @@IDENTITY contains the last identity value that is generated by the statement. If the statement did not affect any tables with identity columns, @@IDENTITY returns NULL. If multiple rows are inserted, generating multiple identity values, @@IDENTITY returns the last identity value generated.

Pasted from <https://docs.microsoft.com/en-us/sql/t-sql/functions/identity-transact-sql?view=sql-server-2017>