That will work if you only need that first @@Identity... but if you need both of the inserts just returning @@Identity will not work... you will have to set it after each insert...
my 2 cents... On 4/18/05, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > 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:203234 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
