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