create table t1(a int identity(1,1)) insert into t1 default value set i

Say if we have a table that contains only a single column ,
say OrderID, which has IDENTITY attribute defined on it. So
how can we insert data in this table.

I am reframing my question, that how can we make the table
to increment the column "OrderID" value several times???

Question Posted / brahma

3 Answers
6666 Views
I also Faced
E-Mail Answers

Answer Posted / brahma

create table t1(a int identity(1,1))
insert into t1 default value

set identity_insert t1 off
(or)
set identity_insert t1 on

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the steps you must follow to hide sql server instances?

978

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

986

What new changes are being made in SQL Server?

1188

How to drop existing views from a database in ms sql server?

1103

In which sql server version report builder introduced?

149

How do you start single user mode in clustered installations?

942

How to maintain a fill factor in existing indexes?

1006

Which table keeps the locking information?

924

How to use go command in "sqlcmd"?

1208

Does a server store data?

928

How to concatenate two strings in SQL Server.

1150

Can we add our custom code in ssis?

988

Explain database normalization?

1229

Define left outer join in sql server joins?

965

How to display a past time in days, hours and minutes?

1016