Mar 09 2023

SQL Server Personal FAQs

di Luigi Boschetti

How to find Duplicates in a Table?

SELECT ColA, ColB, COUNT(*) NumRecords FROM t1 GROUP BY ColA, ColB HAVING COUNT(*) > 1;

References:

You can use the sys.sp_depends:

exec sys.sp_depends 'object_name'

References:

Pubblicato inSQL Server