利用sqlserver查询分析器，批量插入数据

来源：互联网发布：红警全图作弊器软件编辑：程序博客网时间：2024/05/21 06:50

Declare @i int
set @i=1
while @i<100000
begin
if(@i<10)
begin
insert into dbo.product(product_code,type_code,unit_id,status_id,product_name,product_name_ab,price,valid,spec,pic_url,describe,click_count,memo) values('0000'+@i,'01',1,2,'推荐新疆和田玉枣 32元肉厚相当于昆仑山四星','bg',1,'true','','/images/pro_04.jpg','',0,'')
set @i=@i+1;
end
if(@i<100)
begin
insert into dbo.product(product_code,type_code,unit_id,status_id,product_name,product_name_ab,price,valid,spec,pic_url,describe,click_count,memo) values('000'+@i,'01',1,2,'推荐新疆和田玉枣 32元肉厚相当于昆仑山四星','bg',1,'true','','/images/pro_04.jpg','',0,'')
set @i=@i+1;
end
if(@i<1000)
begin
insert into dbo.product(product_code,type_code,unit_id,status_id,product_name,product_name_ab,price,valid,spec,pic_url,describe,click_count,memo) values('00'+@i,'01',1,2,'推荐新疆和田玉枣 32元肉厚相当于昆仑山四星','bg',1,'true','','/images/pro_04.jpg','',0,'')
set @i=@i+1;
end
if(@i<10000)
begin
insert into dbo.product(product_code,type_code,unit_id,status_id,product_name,product_name_ab,price,valid,spec,pic_url,describe,click_count,memo) values('0'+@i,'01',1,2,'推荐新疆和田玉枣 32元肉厚相当于昆仑山四星','bg',1,'true','','/images/pro_04.jpg','',0,'')
set @i=@i+1;
end
if(@i<100000)
begin
insert into dbo.product(product_code,type_code,unit_id,status_id,product_name,product_name_ab,price,valid,spec,pic_url,describe,click_count,memo) values(''+@i,'01',1,2,'推荐新疆和田玉枣 32元肉厚相当于昆仑山四星','bg',1,'true','','/images/pro_04.jpg','',0,'')
set @i=@i+1;
end
end

0 0