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' ;