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
- 6496 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
Explain error handling in ssis?
What is a result set object returned by mssql_query()?
What is the difference between ‘having’ clause and a ‘where’ clause?
Which are ddl commands?
What is difference between standardization and normalization?
What are the differences between stored procedure and the dynamic sql?
What is query processing?
What are null values in ms sql server?
Explain about Normalization?
How to enable/disable indexes?
what do you understand by change data capture?
What happens if null values are involved in comparison operations?
What is scan table/view and seek table/view when its occurs? : sql server database administration
What does indexation mean?
What are sql azure firewall rules?
