★ Tip of The Day: SCOPE_IDENTITY() : It returns the last - TopicsExpress



          

★ Tip of The Day: SCOPE_IDENTITY() : It returns the last identity value generated for any table in the current session and the current scope. suppose we create an insert trigger on table which inserts a row in another table with generate an identity column, then SCOPE_IDENTITY result is not affected but if a trigger or a user defined function is affected on the same table that produced the value returns that identity record then SCOPE_IDENTITY returns that identity record which is created by trigger or a user defined function.
Posted on: Thu, 22 Aug 2013 07:36:25 +0000

Trending Topics



Recently Viewed Topics




© 2015