Easwaran Paramasivam
asked on
Difference between @@identity and scope_identity()
I know that @@identity is scope less and scope_identity() will return inserted value within the scope. In my DB if I replace all @@identity with scope_identity()? Will it work or would have any impact?
If no issue with the replacement why do we need @@identity?
If no issue with the replacement why do we need @@identity?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.
http://msdn.microsoft.com/en-us/library/dd172121(v=vs.100).aspx
Hope that helps.