Try this:
CREATE proc RefreshNo(@aFldName char(40),@aTabName char(40)) AS
declare @i int
Select @i = 0
Update users set 序号=@i , @i=@i+1
CREATE proc RefreshNo(@aFldName char(40),@aTabName char(40)) AS
declare @i int
Select @i = 0
Update users set 序号=@i , @i=@i+1
while mycheck do
begin
exec myproc;
end;