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

What is the purpose of grouping data in a report?

924

Explain syntax for disabling triggers?

992

Does a full backup include transaction log?

925

Can a database be shrunk with users active?

1086

What is user defined datatypes and when you should go for them?

983

What is SubQuery in SQL Server 2008

984

How will you make an attribute not process? : sql server analysis services, ssas

1033

What are basics of policy management?

1062

What Is Rdbms?

1104

Please explain what is “asynchronous” communication in sql server service broker?

896

List some advantages and disadvantages of stored procedure?

985

Define inner join in sql server joins?

1007

What is the difference between commit and rollback?

897

What is the default Port No on which SQL Server listens?

1087

What's new in sql management studio for sql server? : sql server management studio

1025