select * from table_name 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 / karthikeyan

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

Answer Posted / karthikeyan

select * from table_name order by id;

Is This Answer Correct ?

1 Yes

14 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to create a ddl trigger using "create trigger" statements?

1138

Tell about MOM Tool(Microsoft Operator Manager)?

1919

Mention the command used to rename the database.

1016

How to drop existing views from a database in ms sql server?

1109

How to create a new login name in ms sql server?

1074

what are database files and filegroups? : Sql server database administration

953

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

1082

What is dirty page?

979

how to invoke a trigger on demand? : Sql server database administration

1091

What is the sql case statement used for?

1106

what method you can use to reduce the overhead of Reporting Services data sources?

258

What is the size of transaction log file?

931

Does partitioning improve performance sql server?

987

How to concatenate two binary strings together?

1136

What are the types of resultset?

970