T-SQL Analyzer

# SQL Server Rule: SRD0056 | | | |----|----| | Assembly | SqlServer.Rules | | Namespace | SqlServer.Rules.Design | | Class | AvoidUseOfIdentityFunction | ## Rule Information | | | |----|----| | Id | SRD0056 | | Friendly Name | Unsafe identity retrieval | | Category | Design | | Ignorable | true | | Applicable Types | Dml Trigger | | | Procedure | | | Scalar Function | | | Table Valued Function | ## Description Use OUTPUT or SCOPE_IDENTITY() instead of @@IDENTITY. ## Summary Use OUTPUT or SCOPE_IDENTITY() instead of @@IDENTITY ### Remarks The rule checks the code for using any of the `@@IDENTITY` function. When the queries use parallel execution plans, the identity functions may return incorrect results. _{^{Generated by a tool}}