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 are the types of containers in ssis?
Do you know what is sql service broker?
What is a mixed extent?
What is coalesce in sql server?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What is user-defined function?
What are differences in between sql server 2012 and sql server 2016?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
Why do we use trigger?
What is server-level principal?
If user is owning any SQL Objects, can we drop that user
Explain what are the basic functions for master, msdb, model, tempdb databases?
What are the steps to insert a table?
what are the new features in SSRS?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions