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

We need to perform what steps in the following order to work with a cursor?

1220

What is an sql server agent?

1069

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1063

How many instances per computer are there in sql server 2000?

1080

What is full outer join in sql server joins?

1072

How extra digits are handled with numeric data type literals?

972

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1068

Describe in brief authentication modes in sql server.

1031

What is self contained multi valued query?

1021

What are different types of roles provided by ssrs?

150

What is a transactions?

1041

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1006

What is a not null constraint?

1035

What is table level trigger?

1026

Does the order of columns in update statements matter?

916