Mike Kear wrote: > Michael got the extract right. True, books on line doesnt say NOT to > use @@identity, but it does say it's risky if there are several > inserts going on at once.
again, where exactly does it say that? > > @@IDENTITY gives you the identity from the last insert in the > database, whereever it was. Which might or might not be the one you that is an urban myth or a lack of understanding of how IDENTITY works, take your pick. but repeatedly saying that sort of thing based on the BoL as reference when it obviously isn't, doesn't make any sense to me. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:203214 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
