1. 逐行更新 Create Table Controls ( id uniqueidentifier not null, typeid int not null, code nvarchar(10) null, Sort int null, ) GO insert into Controls select newid(), 1, null, null insert into Controls select newid(), 1, null, 1 insert into Controls select newid(), 1, null, null insert into Controls select newid(), 2, null, null insert into Controls select newid(), 2, null, 3 insert into Controls select newid(), 3, null, null insert into Controls select newid(), 1, null, null insert into Controls select newid(), 3, null, 7 insert into Controls select newid(), 2, null, null select * from Controls DECLARE @i SMALLINT SET @i = 0 UPDATE Controls SET @i = @i + 1, Sort = ISNULL(Sort, @i), Code = 'Control-' + LTRIM(STR(@i)) select * from Controls