0
kicks
Different ways to get IDENTITY of New Inserted Rows in SQL Server
There are different methods to know the Identity Value of a newly added row - Current Scope, Current Session, and Irrespective of Current Scope and Session