Skip to content

KC's Blog

  • Home
  • About Me
  • Sitemap

database

How to remove duplicate records from a table in SQL database

December 10, 2009January 24, 2023 Kent ChenMicrosoft

Scenario 1, one record is completely identical to another Meaning that there is no way of identifying them who is who. Usually, it happens when the table doesn’t have a unique id field due to the poor database design. Because of that, there is no way in SQL to delete one of these duplications without deleting them all first. You […]

Read more
  • Difference between Kubernetes and Docker with ChatGPT versions
  • How To Change the Owner of A User’s OneDrive Data
  • RE4ncJa - Deploying Microsoft Edge Extensions via Group Policy
    Deploying Microsoft Edge Extensions via Group Policy
  • Download Large VMDK Files Faster from VMware Host Faster
  • Email Stopped Working in Spiceworks HelpDesk Server

KC's Blog

  • Home
  • About Me
  • Sitemap
Powered by WordPress | Theme: Astrid by aThemes.