Whoah there horsey - both of your last posts were unnecessary. Paul is exactly correct - the BOL does *NOT* say or advise or warn against using any method. As you will have seen from posts over the years he is a very advanced developer who offers educated and informed technological insights (just don't get him started on Unicode) - he asked a question - as did I about where BOL mentioned this oddity, I have used SQL Server for a long time and never once see or had a behaviour where I was not to use @@.
Take this case If I am running an SP which does an insert and I have a @@IDENTITY after the insert then it will ALWAYS give me the correct entry for that last run insert in that scope - i.e. the SP, not matter how many people run it at the same time. -----Original Message----- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 15:08 To: CF-Talk Subject: Re: Last ID inserted I already spelled it out twice, and with the quote of Michael's (who beat me to the punch there by about 4 minutes) there are the references from the BoL. A lot of people have the wrong idea about what @@IDENTITY does, and as a result are open to risk. If you can't see that in what I wrote, I dont know how you got to where you are in this business. My absolute last on this subject. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 4/19/05, Paul Hastings <[EMAIL PROTECTED]> wrote: > Mike Kear wrote: > > Ok Paul please yourself I dont care a *&^$. Life's too short to argue. > > who's arguing? i was just asking you to clarify your "opinions". which > you aren't doing. so i guess that's the end of that. > > > You do whatever the hell you like. > > well i do *like* facts to be factual. how about you? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203231 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54