2.Identify Duplicate Records
1. Updating Columns
USE <DATABASENAME>
GO
SELECT COLUMN_NAME,
DATA_TYPE,
COLUMN_NAME + ' = ' + CASE
WHEN DATA_TYPE = 'VARCHAR'
THEN 'SUBSTRING(DPS.' + COLUMN_NAME + ' ,1, ' + CAST(CHARACTER_MAXIMUM_LENGTH AS VARCHAR(3)) + '),'
ELSE 'DPS.' + COLUMN_NAME + ','
END
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = <TABLE_NAME>
GO
