[jaango123]

Can you me know whether the below statement is correct.

create table testtable
(id int identity(1,1) primary key,
name varchar(20) not null)


insert into testtable
values ('test1') , ('test')


if it is wrong, why? where this statement will work fine ??

[Damganpoor@9]

Hai,
U can not insert, because u have given that it is identity column.. it automatically increments as of ur second column..which is inserted.