Say if we have a table that contains only a single column , say OrderID, which

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 / vampire007

3 Answers
5897 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attrib..

Answer / madhu

To insert values into Identity column use the
IDENTITY_INSERT option like

SET IDENTITY_INSERT Table_Name ON
Insert Table_Name
(OrderID)
Values(10)
SET IDENTITY_INSERT Table_Name OFF

Is This Answer Correct ?

4 Yes

0 No

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attrib..

Answer / 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

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attrib..

Answer / deepak

Madhu, actually the answer which u have given is quite
common. Now i m gonna tell u a new one. The above question
has one more solution that is stated below:

"Insert into Table_name DEFAULT values"

that's it.

Is This Answer Correct ?

1 Yes

4 No

Post New Answer