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
- 25195 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
Who developed sql server?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What are the methods used to protect against sql injection attack?
What is 1nf 2nf and 3nf?
Is candidate a key?
What do you understand by recursive stored procedures?
What factors you will consider calculating the storage requirement for that view?
How can a user-defined datatype be created?
What is sql or structured query language?
How to connect php with different port numbers?
How do we synchronize On-Premise SQL server with SQL Azure?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What are the different types of normalization?
what is the information that can be stored inside a bit column? : Sql server database administration
Can we insert data into view sql server?
