On Fri, May 28, 2010 at 8:46 AM, Grigore Dolghin <[email protected]> wrote: > In adition to Stephen's message - there is a function in SQL server > named SCOPE_IDENTITY() which returns the last ID inserted by you, even > if someone else already inserted records. > > Select Scope_Identity() As MyLastId > > I don't remember exactly when it was introduced, I guess SQL Server > 2005, but anyway. Check it out. --------------------
I don't need no stinkin return for my key value. Guid ID = Guid.NewGuid(); I make them myself! -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
