How To delete duplicate record from a particular table?

Answer Posted / pavan kumar

Mr. Manoj, the system throws error message as "Incrrect
sysntax near 'a'"

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to delete a login name in ms sql server?

699


Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

701


Explain an automatic checkpoint

720


What are the authentication modes in sql server? How can it be changed?

788


What information is maintained within the msdb database?

720






What stored by the master?

714


Can we write trigger for view?

722


What are statistics?

776


What is difference between global temporary tables and local temporary tables?

875


What is tablix?

136


Can group by be used without aggregate functions?

666


What is a database table?

693


What are the advantages of passing name-value pairs as parameters?

825


How to throw custom exception in Stored Procedure?

755


Explain ranking functions?

775