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
- 7930 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
Explain throw statement in sql server 2008?
How to execute a sql statement using odbc_exec()?
What is a partitioned view?
What is sql service broker?
Does the order of columns in update statements matter?
what is database replication? : Sql server database administration
Explain the use of containers in ssis and also their types?
What are the system database in sql server 2008?
query processing
In case you have filters in your report, when filters will be applied in cached report instance?
How can sql injection be stopped? : sql server security
What is sql sandbox in sql server?
Is candidate a key?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
Please differentiate between a local and a global temporary table?
