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
- 7 Answers
- 7951 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
What is clr ddl trigger?
How to set database to be single_user in ms sql server?
what is database replication? : Sql server database administration
What is public role in sql server?
What is deploy, process and build? : sql server analysis services, ssas
What are the disadvantages of merge replication?
What are different types of join?
What is an example of a primary key?
Is it safe to delete log files?
What is store procedure? How do they work? When do you use?
What is 'write-ahead log' in sql server 2000 ?
Do you think BCNF is better than 2NF & 3NF? Why?
What does <> symbol mean?
What is filter index?
What is schemabinding a view?
