How to insert records in a Table having single identity column

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Amit Jethva SSCarpal Tunnel Points: 4707 More actions · Answer 1

Run this ....

INSERT A DEFAULT VALUES

"There is no 'patch' for stupidity."

Rogerio Ueda Karpischek SSC Rookie Points: 26 More actions · Answer 2

If you have more columns like:

CREATE TABLE test

(

ID Int Identity (1, 1)

Name varchar(50)

)

Go

you can:

insert into test (Name) values ('John')

if you don't put a column in the first pharentesis it will be filled with the default value and in this case is the unique number