11 2013 档案

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 MyBeN 阅读(247) 评论(0) 推荐(0)

导航