Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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???

Question Posted / vampire007

Answers were Sorted based on User's Feedback



Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attrib..

Answer / 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

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attrib..

Answer / 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

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attrib..

Answer / deepak

Madhu, actually the answer which u have given is quite
common. Now i m gonna tell u a new one. The above question
has one more solution that is stated below:


"Insert into Table_name DEFAULT values"


that's it.

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More SQL Server Interview Questions

What are the different types of sub-queries?

0 Answers  

What is clustered vs nonclustered index?

0 Answers  

What is a sql join?

0 Answers  

What is t-sql script to take database offline – take database online.

0 Answers  

How to download and install sql server 2005 books online?

0 Answers  

what are different types of raid configurations? : Sql server database administration

0 Answers  

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

2 Answers  

How do I find query history in sql server?

0 Answers  

How to use subqueries with the exists operators in ms sql server?

0 Answers  

What do you understand by check constraint in sql server?

0 Answers  

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  

What are the types of normalization?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories