for more info ..
-- #1 long numbers (Carlo doesn't like for Excel)
CREATE SEQUENCE SSC_ROCKS;
SELECT N0 = (NEXT VALUE FOR SSC_ROCKS); -- -9223372036854775808
SELECT N1 = (NEXT VALUE FOR SSC_ROCKS); -- -9223372036854775807
DROP SEQUENCE SSC_ROCKS;
GO
-- #2 try hex string instead
CREATE SEQUENCE SSC_ROCKX;
SELECT N0 = [sys].[fn_varbintohexstr](NEXT VALUE FOR SSC_ROCKX); -- 0x8000000000000000
SELECT N1 = [sys].[fn_varbintohexstr](NEXT VALUE FOR SSC_ROCKX); -- 0x8000000000000001
DROP SEQUENCE SSC_ROCKX;
GO
-- #3 show that ROLLBACK doesn't erase/reset sequence, ie behaves like IDENTITY()
CREATE SEQUENCE SSC_ROCKT;
begin tran
SELECT N0 = [sys].[fn_varbintohexstr](NEXT VALUE FOR SSC_ROCKT); -- 0x8000000000000000
SELECT N1 = [sys].[fn_varbintohexstr](NEXT VALUE FOR SSC_ROCKT); -- 0x8000000000000001
rollback
SELECT N2 = [sys].[fn_varbintohexstr](NEXT VALUE FOR SSC_ROCKT); -- 0x8000000000000002
DROP SEQUENCE SSC_ROCKT;
GO