Returning the Last Identity Value
3> 4> SELECT IDENT_CURRENT('YourTableName') LastIdententityValue 5> GO LastIdententityValue ---------------------------------------- NULL (1 rows affected) 1>