动态更新序列号

        WITH CTE_A AS(        SELECT *, ROW_NUMBER() OVER(PARTITION BY CSVFileName ORDER BY SeqID ASC) AS RN        FROM {2} (NOLOCK)        WHERE CSVFileName = @CSVFileName        )        UPDATE CTE_A        SET    CSVLineNo = RN+1;