Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Return identity value from newly inserted record
Message
From
05/10/2001 11:57:54
Bob Archer
Tampa, Florida, United States
 
 
To
05/10/2001 08:11:36
Michael Levy
Cincinnati, Ohio, United States
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Return identity value from newly inserted record
Miscellaneous
Thread ID:
00564540
Message ID:
00564842
Views:
21
>Use SCOPE_IDENTITY() if you're using SQL Server 2000. @@IDENTITY can cause issues when dealing with nested INSERT triggers.
>
>-Mike

Right, and actually there are ways to fix that issue also.

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=9736

BOb
Previous
Reply
Map
View

Click here to load this message in the networking platform