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
- 7477 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
Do you know what are the restrictions that views have to follow?
What is an inner join?
What is the difference between a clustered index and a non-clustered index?
What is raiseerror? What is raiseerror?
How can you append an identity column to a temporary table?
How to create a user name in a database?
What is clustered vs nonclustered index?
What stored by the tempdb ? : sql server database administration
How to select some specific columns from a table in a query in ms sql server?
Define normalisation?
do you know how to configure db2 side of the application? : Sql server database administration
Differentiate sql server reporting services vs. Crystal reports?
How to return the date part only from a sql server datetime datatype?
Explain Capacity planning to create a database? and how to monitor it?
What is difference between standardization and normalization?
