Difference Between @@identity , scope_identity() and ident_Current('tablename'):- SELECT @@IDENTITY @@IDENTITY is limited to the current session, it is not limited to the current scope. SELECT SCOPE_IDENTITY() SELECT IDENT_CURRENT(‘tablename’) IDENT_CURRENT is not limited by scope and session; it is limited to a specified table.
Comments
Post a Comment