SQL 循环插入多条数据

   在开发中经常需要用大量数据来测试，在没有数据的情况下，自己一条一条的插入事在不大可能，用SQL语句，一下就OK了，具体实现如下：

 sql下代码： //声明变量； DECLARE @i int DECLARE @name varchar(10) DECLARE @password varchar(10) Set @i = 1000 //开始循环插入数据； WHILE @i < 1000 BEGIN Set @i =@i +1 SET @name = RIGHT('00000' + CAST(@i AS varchar(10)),5) set @password = @name insert into admin values(@name,@password) END （2）oracle下代码： (1)先理论 declare i number; begin i := 1; while i<=100 loop dbms_output.put_line(i); i := i+1; end loop; end; (2)实践 declare year varchar2(4):='2008'; month number(2):=1; schoolid number(10):=14640; begin loop loop insert into xx_jb1 (ID, XXID, GLBMJY, XXXZGB, XXLS, HJXX, HJXS, LX_TZH_XX, LX_TZH_XS, BGNF, BGYF, STATE, SSRQ, TJRQ, TBR) values (seq_xx_jb1.nextval, schoolid, 1, 1, 2, 1, 248, 1, 248, year, month, '已通过', sysdate, sysdate, '管理员'); month := month+1; exit when month>12; end loop; month := month-12; schoolid := schoolid+1; exit when schoolid>15040; end loop; end;