Is it possible to delete duplicate rows in a table without
using a temporary table ?
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
What triggers long term care?
What is built-in function?
What is the language structure to add a record to a table?
Write a sql query to sort on different column name according to the parameters passed in the function?
How can sql server instances be hidden?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What is the use of group by clause?
When would you use it?
What is identity?
What does the on delete cascade option do?
What is executereader?
How can we determine what objects a user-defined function depends upon?
How many types of triggers are there?
What are the different types of backups that exist?
What is openrowset sql server?