AutoNumber in SQL server

[User 3738736]

Does SQL Server have an autonumber datatype which will increment when adding record Karabo Mekgwe

[Krish KP]

YES. CREATE TABLE tblA( AutoID decimal(18, 0) NOT NULL IDENTITY (1, 1), Col2 varchar(10) )

[RavikumarR]

yes that s IDENTITY See the example : CREATE TABLE Emp (EMPID int IDENTITY (1, 1) NOT NULL ,EMPNAME VARCHAR(20)) Above this examble Identity is like an auto increment. The Parameters (1,1) represents Start Number, Increment Number this example starts 1 and next incremented by 1 RK RK

RK

[RavikumarR]

yes that s IDENTITY See the example : CREATE TABLE Emp (EMPID int IDENTITY (1, 1) NOT NULL ,EMPNAME VARCHAR(20)) Above this examble Identity is like an auto increment. The Parameters (1,1) represents Start Number, Increment Number this example starts 1 and next incremented by 1

RK