存储过程来更新表中在SQL Server中具有重复值的行

CREATE PROCEDURE UpdateDuplicateRows
AS
BEGIN
    SET NOCOUNT ON;

    -- 创建临时表来存储重复的行
    SELECT Column1, Column2, COUNT(*) AS DuplicateCount
    INTO #TempTable
    FROM YourTable
    GROUP BY Column1, Column2
    HAVING COUNT(*) > 1;

    -- 更新重复的行
    UPDATE t
    SET Column3 = 'New Value'
    FROM YourTable t
    INNER JOIN #TempTable tt ON t.Column1 = tt.Column1 AND t.Column2 = tt.Column2;

    -- 删除临时表
    DROP TABLE #TempTable;
END