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
- 6647 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
Tell me the phases a transaction has to undergo?
Do you know what are various aggregate functions that are available?
What gets stored inside msdb database?
What is unpivot?
What is cursors?
Explain the stored procedure?
How to test values returned by a subquery with the in operator?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
What is the size of transaction log file?
What do you mean by table and field in sql?
What is 1nf normalization form?
What is normalization 1nf 2nf 3nf?
What is join and name different type of joins?
How many types of cursor type are there?
What is shared lock?
