Friday, August 18, 2006

 
I should've posted this link in my last post, but it didn't cross my mind. Check out:
http://www.sqlteam.com/item.asp?ItemID=8003

I also read recently that when using @@IDENTITY to get the value that was inserted in an identity column, you may get an incorrect value if the table has a trigger defined. That's when SCOPE_IDENTITY is a better choice.

IDENT_CURRENT can be used to get the last identity that was inserted into a table, irrespective of the connection. For more, browse over to:
http://www.sqlteam.com/item.asp?ItemID=319

Comments: Post a Comment



<< Home

This page is powered by Blogger. Isn't yours?