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???
- 3 Answers
- 5903 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
How will you go about resolving deadlocks?
What is abstracting periodical?
What is rs.exe utility?
What protocol does sql server use?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
What are recommended options to be used while using db mirroring? : sql server database administration
Do you know what is blocking?
Does any body please help me what question's have asked for SSRS in the interview?
How to assign null values to variables or columns?
How you can change a cross join into an inner join?
What are the differences between triggers and stored procedures?
What is serializable?
Explain different types of Normalization.
How to receive output values from stored procedures?
Delete duplicate rows without using rowid.
