Mega Code Archive

 
Categories / MSSQL / Sequence
 

Returning the Last Identity Value

3> 4> SELECT IDENT_CURRENT('YourTableName') LastIdententityValue 5> GO LastIdententityValue ----------------------------------------                                     NULL (1 rows affected) 1>