sql循环

declare @orderNum varchar(255)
declare @n int,@rows int
select @rows =10000
set @n=1
while @n<=@rows
begin
  select @orderNum=@n
Insert into gWFDocReleaseLog(doccode, formid, sequence, wfRouteNo, wfRouteSubNo, organization, PlanHrCode, Positionlevel, ActHrCode, 
             ActReleaseDate, ReleaseType, ReleaseMemo, informed, cancelflag, needrelease, canrelease )
   select top(1) doccode+ CAST(@n as varchar(50)), formid, sequence, wfRouteNo, wfRouteSubNo, organization, PlanHrCode, Positionlevel, ActHrCode, 
                ActReleaseDate, ReleaseType, ReleaseMemo, informed, cancelflag, needrelease, canrelease 
from gWFDocReleaseLog2
  select @n=@n+1
end