Example of creation the SEQUENCE in MSSQL:
CREATE SEQUENCE [dbo].[CardNum]
AS [bigint]
START WITH 1
INCREMENT BY 1
MINVALUE -9223372036854775808
MAXVALUE 9223372036854775807
CACHE
GO
That script will create the sequence named CardNum that have type BIGINT and begin from value 1 in current database.
To get new value from SEQUENCE:
set @card_num = NEXT VALUE FOR [dbo].[CardNum];
To just view current properties of SEQUENCE:
SELECT * FROM sys.sequences WHERE name = 'CardNum' ;