sql server 循环插入一些测试数据

DECLARE @i INT,  
@num int  
SET @i=0 
SET @num=100000  
WHILE @i<=@num  
BEGIN  
 IF NOT EXISTS(SELECT * FROM  dbo.meter_manage WHERE meter_id=@i)  
 INSERT INTO dbo.meter_manage  
         ( meter_id ,  
           meter_no ,  
           meter_name   
         )  
 VALUES  
         ( @i , -- meter_id - int  
           'asdasd'+CONVERT(VARCHAR(20),@i), -- meter_no - varchar(500)  
           'asdsf'++CONVERT(VARCHAR(20),@i)  -- meter_name - varchar(500)  
         );  
         SET @i=@i+1;  
END  

DECLARE @i INT, @num INT
SET @i=0
SET @num=10000
WHILE @i<=@num
BEGIN
INSERT INTO dbo.device_to_data_verification_strategy_group
        ( device_id, group_id )
VALUES
        ( @i, -- device_id - int
          1  -- group_id - int
          );
          SET @i=@i+1;
END

DECLARE @i INT,@num INT
SET @i=0
SET @num=1000
WHILE @i<=@num
BEGIN
UPDATE dbo.geo_tree_device SET device_id=@i WHERE id=@i+501
END