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

What are cursors in ms sql server?

1178

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1139

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

900

Is BCNF better than 2NF & 3NF? Why?

1047

How to send email from database?

1013

Explain about analysis services?

1049

What is a database in ms sql server?

1057

What are the kinds of subquery?

1008

What functions can a view be used to performed?

1060

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

1004

What is the main difference between ‘between’ and ‘in’ condition operators?

1191

What is table-valued sub query?

967

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1942

How many databases instances are there in sql server 2000?

1098

Explain the relational database management system (rdbms)?

1097