Skip to content

KC's Blog

  • Home
  • About Me
  • Sitemap

database

How to remove duplicate records from a table in SQL database

December 10, 2009 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
  • image - Why Office 365 GPO Settings Don't Apply? And What To Do?
    Why Office 365 GPO Settings Don’t Apply? And What To Do?
  • PowerShell
    Taking Screenshots with PowerShell on Windows 10
  • image 7 - Fix Windows 10 20H2 Upgrade Error 0xc1900223 via WSUS
    Fix Windows 10 20H2 Upgrade Error 0xc1900223 via WSUS
  • image 3 - How To Connect-MsolService without Login Prompt
    How To Connect-MsolService without Login Prompt
  • directory synchronization - How To Convert A Cloud Account to Azure AD Synced Account in Microsoft 365?
    How To Convert A Cloud Account to Azure AD Synced Account in Microsoft 365?

KC's Blog

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