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

Explain the commands in sql server?

0 Answers  

Why use “nolock” in sql server?

0 Answers  

Can you name some of the dml commands in sql?

0 Answers  

What is the difference between a local and a global variable?

5 Answers  

Explain what are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

What are the differences between char and nchar in ms sql server?

0 Answers  

Do you know what are acid properties?

0 Answers  

Can a cursor be updated? If yes, how you can protect which columns are updated?

0 Answers  

What are the tool windows in sql server management studio? : sql server management studio

0 Answers  

Explain what is meant by replication of database?

0 Answers   Cap Gemini,

What is deploy, process and build? : sql server analysis services, ssas

0 Answers  

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories