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
- 25300 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
What are differences in between sql server 2012 and sql server 2016?
Define right outer join in sql server joins?
where the connection string store in the database
List out a number of the wants to setup a SQL Server failover cluster?
What are the differences between triggers and stored procedures?
How do you know if sql server is running on your local system?
Give me any three differences between Truncate and Delete.
How to insert stored procedure result into temporary table?
what happens on checkpoint? : Sql server database administration
What are basics of policy management?
What is difference between cte and view?
explain different types of backups avaialabe in sql server? : Sql server database administration
What is the return type of executeupdate ()?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
In how many ways you can invoke ssrs reports?
