Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6502 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
Explain security with sql azure?
What is awe?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
What is the cartesian product of the table?
Explain how you can configure a running aggregate in SSRS?
Why use “nolock” in sql server?
Explain about local stored procedure?
Explain “not null constraint” in sql server?
What is index fragmentation in ms sql server?
Where are full-text indexes stored?
How to recompile stored procedure at run time?
Different types of keys in SQL?
Define clusters?
What is intellisense?
Write a query for primary key constraint with identity key word?
