sql server 循环
摘要:declare @i intdeclare @a intdeclare @b intset @i=0while(@i<=20) begin set @a=@i*1000+1; set @b=1000*(@i+1); insert into DYQJYZJ..djsj1(djbh,fwbm,sjsj,sjlx,sjmc,sjimage,sjsl,sjsybz,syewsj,sfbcsj,ys,bz,[type],neworold,yq) select djbh,fwbm,sjsj,sjlx,sjmc,sjimage,sjsl,sjsybz,syewsj,sfbcsj,y...
阅读全文
posted @ 2013-11-11 10:15
浙公网安备 33010602011771号