At 7/1/00 12:44 PM, you wrote:
> > Using the @@IDENTITY variable isn't guaranteed to be
> > correct under heavy load from my understanding.
>
>thats an urban myth. it scales just fine.
I just read the recent discussion on the forums
(http://forums1.allaire.com/DevConf/Thread.cfm?&&Message_ID=504660&_#Message504660)
about this. I had the impression the @@IDENTITY function returned the
last identity value used by the SQL server, regardless of user. This was
wrong. It's the last identity value used by that connection.
As mentioned in the thread by Paul, there are several ways to do it with
SQL server.
I agree the best way is using a SP. Thanks Paul!
Tom
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
