SRD0056.md

SQL Server Rule: SRD0056

Assembly	SqlServer.Rules.dll
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