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
- 5694 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
OPTIMIZATION OF SP,CURSOR,TRIGGERS
How to concatenate two binary strings together?
What type of Index will get created after executing the above statement?
How to update values in a table with update statements in ms sql server?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
Explain trigger classes i.e. Instead of and after trigger?
Explain how many normalization forms?
What are the various editions of sql server 2017 that are available in the market?
Explain activity monitors
can an automatic recovery be initiated by a user? : Sql server administration
How are the exceptions handled in sql server programming?
Do you know data definition language, data control language and data manipulation language?
What is the difference between nvl and nvl2?
What is sub query and its properties?
What do you mean by recursive stored procedure?
