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

here id col have primary key and identity
id name
1 a
2 b
3 c
4 d

delete 2nd row then o/p will be

id name
1 a
3 c
4 d

next inssert 2nd row and i want o/p will be
id name
1 a
2 e
3 c
4 d

Question Posted / guest

Answers were Sorted based on User's Feedback



here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row ..

Answer / challa yerriswamy

set identity_insert <table_name> on
insert into text1(id,id_name) values(2,'insertedat2')

Is This Answer Correct ?    13 Yes 0 No

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row ..

Answer / qwerty

set identity_insert <table_name> on
insert into <table_name>(id,name) values(2,'e')
set identity_insert <table_name> off

Is This Answer Correct ?    12 Yes 0 No

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row ..

Answer / sunilkumar

set identity_insert on
insert into test1(Id ,id_name) values (2 ,'insertedat2')

Is This Answer Correct ?    7 Yes 3 No

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row ..

Answer / boby

insert into <table_name>(id,name) values(2,'e')ORDER BY ID

Is This Answer Correct ?    1 Yes 0 No

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row ..

Answer / pradeep aryan

set identity_insert on
insert into test1(Id ,id_name) values (2 ,'e')
set identity_insert off

Is This Answer Correct ?    0 Yes 3 No

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row ..

Answer / s pattnaik

SET IDENTITY_INSERT dbo.test1 OFF
Then
insert into test1(Id ,id_name) values (2 ,'insertedat2')

Is This Answer Correct ?    6 Yes 12 No

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row ..

Answer / karthikeyan

select * from table_name order by id;

Is This Answer Correct ?    1 Yes 14 No

Post New Answer

More SQL Server Interview Questions

What is triggers in ms sql server?

0 Answers  

Explain system views?

0 Answers  

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

What is bit data type? What's the information that can be stored inside a bit column?

0 Answers  

What is the difference between char and varchar2 datatype in sql?

0 Answers  

What are the advantages of user defined function?

0 Answers  

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

0 Answers  

What is the purpose of the master database?

0 Answers  

what is a self join? : Sql server database administration

0 Answers  

can any one please send sql quries most used in applications.

2 Answers  

Explain the flow of creating a cube? : sql server analysis services, ssas

0 Answers  

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories