Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to delete duplicate rows in a table without
using a temporary table ?
- 12 Answers
- 25233 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ambuj tayal
Yes, it is possible by using in memory table variables on
SQL server 2000 and above.
A table variable can be created and all disticnt values can
be inserted into this table and then deleting all rows from
first table you can insert back disticnt rows to back to
original table. Table variable would automatically be
destroyed whenever bacth execution finishes.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Can we call future method from trigger?
How to join two tables in a single query in ms sql server?
What is sharding?
What are the character string functions supported by sql server 2005?
What is apply operator in sql?
How to verify the port number of the sql server?
What is a collation?
What is the maximum size of a row in sql server?
how can u get last observation in an unknown dataset ?
What does it mean to normalize a database and why would you do it?
Explain transaction server distributed transaction?
In which sql server version report builder introduced?
What is shared lock?
If the job running very slow what is the action you do
What is the use of group by clause?
