Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9296 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
What are the aggregate and scalar functions?
What is similarity and difference between truncate and delete in sql?
How does stuff differ from the replace function?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
explain different levels of normalization? : Sql server database administration
explain declarative management framework (dmf) in sql server 2008?
What is a group function explain with an example?
What languages bi uses to achieve the goal?
What is RAID? What are the different types of RAID configurations?
What is an identity?
What is data compression? : sql server database administration
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What are the basic functions for master, msdb, model, tempdb and resource databases?
which table keeps the locking information? : Sql server administration
What are secondary xml indexes?
