Post a Comment On: SqlInk

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