Is it possible to delete duplicate rows in a table without
using a temporary table ?
Answer Posted / ghous
using cursor is another option
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What are the instances when triggers are appropriate?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Difference between 2NF &3NF ?
What is unique key constraint?
What do you understand by a stored procedure?
What is system stored procedures?
What are sql server functions?
what is a deadlock? : Sql server database administration
What are the types of database recovery models?
How to bind a view to the schema of the underlying tables?
Where cross join is used?
Explain having clause and where clause?
What do you mean by a dependent functionality in a build?
How to optimize stored procedures in sql server?
How to create “dependant” parameter “make, model, year”