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

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

7 Answers
8791 Views
IBM, TCS, I also Faced
E-Mail Answers

Answer Posted / boby

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

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Differentiate between delete and truncate.

994

How to rename an existing column with sql server management studio?

948

Do you know what is difference between stored procedure and user defined function?

1031

Do you know what are different types of replication in sql server?

1036

What is key set driven?

893

Explain what are the database objects? : SQL Server Architecture

1004

What is inline variable assignment?

975

What are wait types?

1019

What happens if an integer is too big for int date type?

920

Explain the microsoft sql server delete command?

948

What is stored procedures?

955

Why people hate cursor?

1096

‘Order by’ is not allowed in a view how can you sort information from a view?

1019

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1024

Difference between uniqe index and uniqe constraint?

915