Wednesday, April 02, 2014

Check for duplicates SQL

SELECT
    contentid, contenttypefieldid, COUNT(*)
FROM
    contentvalue
GROUP BY
    contentid, contenttypefieldid
HAVING
    COUNT(*) > 1

Fixes to common .NET problems, as well as information on .NET features and solutions to common problems that are not language-specific.

Fixes to common .NET problems, as well as information on .NET features and solutions to common problems that are not language-specific.

Z