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

Define union, union all, minus, intersect?

974

Explain the microsoft sql server delete command? : SQL Server Architecture

1077

What is rank function?

1020

What are different types of statement?

1010

How to locate and take substrings with charindex() and substring() functions?

1016

How would you use user_constraints table in DB?

1004

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1923

what is denormalization and when would you go for it? : Sql server database administration

1171

How do you set a trace flag in sql server?

1033

Explain Geometry datatype in sql server 2008 with example

985

Explain the architecture of ms sql reporting service?

918

Give me any three differences between Truncate and Delete.

1101

Describe and explain about SQL native client?

1104

Can we use where clause in union?

1063

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

982