Returning the Last Identity Value : IDENT_CURRENT « Sequence « SQL Server / T-SQL






Returning the Last Identity Value

 

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

(1 rows affected)
1>

 








Related examples in the same category

1.Retrieving the IDENT_CURRENT() Value