Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Return identity value from newly inserted record
Message
From
05/10/2001 08:11:36
Michael Levy
Cincinnati, Ohio, United States
 
 
To
04/10/2001 22:17:57
Bob Archer
Tampa, Florida, 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:
00564685
Views:
22
Use SCOPE_IDENTITY() if you're using SQL Server 2000. @@IDENTITY can cause issues when dealing with nested INSERT triggers.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform