Is it possible to delete duplicate rows in a table without
using a temporary table ?
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 open database communication (odbc)?
What is sql server replication? : sql server replication
Explain Geometry datatype in sql server 2008 with example
How to download microsoft sql server 2005 express edition?
What can be used instead of trigger?
What is store procedure? How do they work?
Why union all is faster than union?
what is package and it uses and how can u call a package
What is Dependency Injection and provide example?
Tell me what do we need queues in sql service broker?
Can you pass expressions to function parameters?
What is user-defined scalar function?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
Explain syntax for viewing, dropping and disabling triggers?
Do you know data definition language, data control language and data manipulation language?