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???
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
What is sql view?
What is role playing dimension with two examples? : sql server analysis services, ssas
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
How except clause is differs from not in clause?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is database replication?
What is bcnf normalization form?
Which sql server table is used to hold the stored procedure scripts?
What are the types of table?
How to convert binary strings into integers in ms sql server?
What languages bi uses to achieve the goal?
Can you explain what is indexed view? How to create it?
Explain what is “asynchronous” communication in sql server service broker?
What is the boxing and unboxing concept in .net?
Can we write trigger for view?