//自定义字符串
declare @orderNum varchar(255)
//创建虚拟表
create table #ttableName(id int identity(1,1),Orders varchar(255))
//自定义自然数和行数
declare @n int,@rows int
//将要操作的数据查询出来，插入到创建的虚拟表钟
insert #ttableName(orders) select userID from DEV_USER where USERID not in (select CODE_OPT from SYS_MKQXOPT where SYS_CODE = '05')
--select @rows=count(1) from pe_Orders
//将行数赋予rows自定义行数
select @rows =@@rowcount
//自然数n赋值为1
set @n=1
//while循环，当自然数n小于等于行数时执行循环
while @n<=@rows
//开始
begin
//此处操作虚拟表查出第n行数据，用于操作数据
insert into SYS_MKQXOPT (CODE_OPT,SYS_CODE,Type) values ((select Orders from #ttableName where id=@n),'05','1')
//打印字符串
print (@OrderNum)
//n即行数+1
select @n=@n+1
//结束
end
//删除虚拟表
drop table #ttableName
