sql query with auto increament

You have to use Identity propertes for the column
Make Identity : Yes
Identity Seed - From which valule will ne start
Identity Increment - Incremented by value

u can create table like

create table a
(id int identity(1,1))

hey this is the example:-


create table employee
( id int identity(100,1),
name varchar(100))


here identity start from 100 and increment by 1 automatically with each entry...........