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
- 6620 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
Give an example of why you would want to denormalize a database
What is the standby server?
What is a rollup clause?
Explain what stored procedure sp_replcounters is used for? : sql server replication
What command is used to create a database in the sql server and how?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
How to drop an existing user defined function in ms sql server?
What is updatable resultset?
What happens to a statement batch if there is a compilation error?
How do I view a stored procedure in sql server?
Explain candidate key, alternate key, and composite key?
Explain ms sql server reporting services vs crystal reports?
What is difference between materialized view and view?
How to count duplicated values in a column in ms sql server?
Can you create a logon trigger in sql server 2005 express edition?
