Sequence MSSQL

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