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
- 25683 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
How can you find out how many rows returned in a cursor?
Why use identity in sql server?
what is database replication? : Sql server database administration
Is sql server free?
What do you mean by data manipulation language?
Define the one-to-one relationship while designing tables.
What is transaction server consistency?
What do you understand by mirroring?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
How to rebuild the master database?
What is meant by Active-Passive and Active-Active clustering setup?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
Why we should not use triggers?
What do we have to check in database testing?
How many types of objects are there?
