当列值发生更改时，如何将组编号添加到SQL Server 2012中的连续记录？

SELECT 
    column1,
    column2,
    column3,
    ROW_NUMBER() OVER (ORDER BY column1) AS row_num,
    SUM(CASE WHEN column1 = LAG(column1) OVER (ORDER BY column1) THEN 0 ELSE 1 END) OVER (ORDER BY column1) AS group_num
FROM 
    your_table

WITH numbered_rows AS (
    SELECT 
        column1,
        column2,
        column3,
        ROW_NUMBER() OVER (ORDER BY column1) AS row_num,
        SUM(CASE WHEN column1 = LAG(column1) OVER (ORDER BY column1) THEN 0 ELSE 1 END) OVER (ORDER BY column1) AS group_num
    FROM 
        your_table
)
UPDATE numbered_rows
SET group_number = group_num