22,209
社区成员
发帖
与我相关
我的任务
分享
DECLARE @seq INT = 0;
UPDATE test SET xx = @seq, @seq = @seq + 1;
UPDATE t
SET xx = b.seq
FROM dbo.test t
INNER JOIN(SELECT id, ROW_NUMBER() OVER (ORDER BY id) seq FROM test)b ON b.id = t.id;