我想往数据表加批量加入一些数据,主键自动加1,循环插入,现在写了以下语句,执行不了,请高手帮助!declare@iintset@i=1while@i<800begininsertintoecs_goods_attr(goods_id,attr_i...
我想往数据表加批量加入一些数据,主键自动加1,循环插入,现在写了以下语句,执行不了,请高手帮助!
declare @i int
set @i=1
while @i<800
begin
insert into ecs_goods_attr(goods_id,attr_id,attr_value,attr_price) value(@i,1,a,0);
insert into ecs_goods_attr(goods_id,attr_id,attr_value,attr_price) value(@i,2,b,0);
insert into ecs_goods_attr(goods_id,attr_id,attr_value,attr_price) value(@i,3,c,0);
insert into ecs_goods_attr(goods_id,attr_id,attr_value,attr_price) value(@i,4,d,0);
insert into ecs_goods_attr(goods_id,attr_id,attr_value,attr_price) value(@i,5,e,0);
insert into ecs_goods_attr(goods_id,attr_id,attr_value,attr_price) value(@i,6,f,0