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
- 26141 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ruban
Use ROWID function. It's available only sql server 2005 and
greater
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the largest component inside a field?
Explain the relational database management system (rdbms)?
How to find tables without indexes?
How to insert new line characters into strings?
What is TDS(Tabular Data Stream) Gateway?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
Describe in brief sql server monitoring ways.
Write a program using SQL queries to find a unique entry in a table.
How to rebuild the master database?
What is data block and how to define data block size?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What is index fragmentation in ms sql server?
What are Row versions of DataRow?
Explain hostprotectionattribute in sql server 2005?
What is cursors?
