Friday, August 18, 2006

I should've posted this link in my last post, but it didn't cross my mind. Check out:

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:

Comments: Post a Comment

<< Home

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