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
- 6775 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
Can we call future method from trigger?
Explain SSRS Architecture?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
How do you create a data source?
How can I track the changes or identify the latest insert-update-delete from a table?
what is the primary use of the model database? : Sql server administration
Do you know what is openxml in sql server?
What is similarity and difference between truncate and delete in sql?
What area unit the various kinds of info compression introduced in sql server 2008?
Explain the concept of view and Types of views in SQL server?
How does stuff differ from the replace function?
what are the different types of SSRS reports?
What is Sqlpaging in SqlServer 2005 ?
Explain different types of Normalization.
Write a sql query to display the current date?
