Home

Rule description

• @@IDENTITY should not be used

Non-compliant Code Example

Declare @id INT;
SET @id = @@IDENTITY    --Non compliant code

Compliant Code Example

Declare @id INT;
SET @id = SCOPE_IDENTITY()    --Compliant code