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
- 26122 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
Explain different types of Normalization.
What is failover clustering overview?
How to find index size for each index on table?
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?
What Are the Main Features of SQL Azure?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
What is the meaning of sql server?
What are the system database in sql server 2008?
What are sub reports and how to create them?
Explain identity in sql server?
Differentiate between sql temp table vs table variable?
Write SQL queries on Self Join and Inner Join.
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
What is the difference between nvl and nvl2?
What are indexes in ms sql server?
