SELECT SCOPE_IDENTITY() : SCOPE_IDENTITY « Sequence Indentity « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Sequence Indentity
3. SCOPE_IDENTITY

1> CREATE TABLE customer
2> (
3> cust_id      smallint        IDENTITY(100, 20)  NOT NULL,
4> cust_name    varchar(50)     NOT NULL
5> )
6> GO
1>
2> INSERT customer (cust_name) VALUES ('AAA Gadgets')
3> SELECT SCOPE_IDENTITY()
4> GO

(1 rows affected)

----------------------------------------
                                     100

(1 rows affected)
1>
2> drop table customer;
3> GO