Peter Petrov’s Weblog

var me = from practice in programming where practice.IsBestPractice && practice.UseLambda select practice.OptimalPerformance;

SCOPE_IDENTITY() vs @@IDENTITY – 1:0 September 19, 2008

Filed under: Note to self,SQL — ppetrov @ 4:55 pm
Tags: , ,

@@IDENTITY returns the most recently created identity for your current connection, not necessarily the identity for the recently added row in a table. Always use SCOPE_IDENTITY() to return the identity of the recently added row.