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
- 6665 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhu
To insert values into Identity column use the
IDENTITY_INSERT option like
SET IDENTITY_INSERT Table_Name ON
Insert Table_Name
(OrderID)
Values(10)
SET IDENTITY_INSERT Table_Name OFF
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Which is the main third-party tool used in sql server?
What is sql server 2000 work load governor?
Write a SQL query to delete a table?
What is the datatype of rowid?
What is an index. What are the types?
How to drop existing views from a database in ms sql server?
What is full outer join in sql server joins?
Why truncate is ddl?
What are the database objects? : SQL Server Architecture
What is the sql case statement used for?
How many triggers are possible per table?
How to use clusters?
Why use triggers?
What is an identity?
What are the different editions available in sql server 2000?
