我有一个book字段分别为:
recid(vchar(25),Not Null),
register_no(vchar(20), Null),
publisher(vchar(200), Null),
price(numeric(28,4),Null),
user_id(vchar(50),Null),
DepartName(vchar(100),Null)
有一个数据:
200905230396807150516,
00000002,
'陕西焱晟科技有限公司',
20,
'ISA',
null ,
怎么用语句在查询分析器里面批量增加?
或者如何用批量增加? 急求,诚谢!
recid(vchar(25),Not Null),
register_no(vchar(20), Null),
publisher(vchar(200), Null),
price(numeric(28,4),Null),
user_id(vchar(50),Null),
DepartName(vchar(100),Null)
有一个数据:
200905230396807150516,
00000002,
'陕西焱晟科技有限公司',
20,
'ISA',
null ,
怎么用语句在查询分析器里面批量增加?
或者如何用批量增加? 急求,诚谢!
insert into book
select '200905230396807150516','00000002','陕西焱晟科技有限公司',20,'ISA',null
union all
select '200905230396807150516','00000002','陕西焱晟科技有限公司',20,'ISA',null
union all
select .......
union all
select ...
set @rowcount=0while @rowcount<1000
begin
insert into book
select '200905230396807150516','00000002','陕西焱晟科技有限公司',20,'ISA',null
set @rowcount=@rowcount+1
end
select '200905230396807150516','00000002','陕西焱晟科技有限公司',20,'ISA',null
union all
select '200905230396807150516','00000002','陕西焱晟科技有限公司',20,'ISA',null
union all
select .......
union all
select ...