Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
@@Identity with cascading inserts
Message
From
29/11/2001 16:54:48
Michael Levy
Cincinnati, Ohio, United States
 
 
To
29/11/2001 14:43:07
Ken Matson
GCom2 Solutions
Aston, Pennsylvania, United States
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Re: @@Identity with cascading inserts
Miscellaneous
Thread ID:
00587676
Message ID:
00587751
Views:
23
The best solution is to upgrade to SQL Server 2000. SQL Server 2000 has a new function SCOPE_IDENTITY() that corrects this issue.

For SQL Server 7, this is the only thing that I've seen:

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

good luck.

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

Click here to load this message in the networking platform