To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 11, 2004 1:35 PM
Subject: Re: Reliable way to get ID of inserted record
> Be carefull using @@IDENTITY, as it can return erroneous information
(especially if your tables have triggers associated with them). If you are
using SQL Server 2000, use the SCOPE_IDENTITY() function instead of
@@IDENTITY.
Oooh! Use it in an example please! And how exactly *can* this produce
erroneous info?
Jeff,
always used @@IDENTITY...and is now scurred...
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
