Neat article. I used it to automate a check for duplicates.
CREATE PROCEDURE DBO.SP_DUPLICATE_CHECK
@TABLE NVARCHAR(255),
@CLM NVARCHAR(255)
AS
BEGIN
DECLARE @CMD NVARCHAR(255)
SET @CMD =
'SELECT ' +
@CLM +
',COUNT(*) AS CNT' +
' FROM ' + @TABLE +
' GROUP BY ' + @CLM +
' HAVING COUNT(*) > 1'
EXEC SP_EXECUTESQL @CMD
END
GO
EXEC DBO.SP_DUPLICATE_CHECK 'TABLE_NAME','COLUMN1, COLUMN2, ETC.'