Mega Code Archive

 

Categories / MSSQL Tutorial / Sequence Indentity

 

IDENTITY(100, 20)

2>  CREATE TABLE customer 3> ( 4> cust_id      smallint        IDENTITY(100, 20)  NOT NULL, 5> cust_name    varchar(50)     NOT NULL 6> ) 7> GO 1> 2> SELECT IDENT_CURRENT('customer') 3> GO ----------------------------------------                                      100 (1 rows affected) 1> 2> drop table customer; 3> GO 1>