Declare @listno varchar(2) --假设Listno为主键
Declare @invno int
select @invno=1
Declare List_cur Cursor
FOR select Listno from List Where invno is null
OPEN List_cur
FETCH NEXT FROM List_cur INTO @listno
WHILE (@@FETCH_STATUS =0 )
BEGIN
UPDATE List SET invno=@invno WHERE Listno=@listno
Select @invno =@invno+1
FETCH NEXT FROM List_cur INTO @listno
END
CLOSE List_cur
DEALLOCATE List_cur