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
- 6654 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
Disadvantages of the indexes?
What is a print index?
What happens when converting big values to integers?
What is a trigger what are the advantages of trigger?
Do you know what are the restrictions that views have to follow?
Explain the difference between function and stored procedure?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
explain the storage models of olap? : Sql server database administration
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
can an automatic recovery be initiated by a user? : Sql server administration
What are the benefits of filtered indexes?
What is the purpose of grouping data in a report?
How many types of database relationship in sql server?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
Which are ddl commands?
