1. 数据库怎么循环插入数据

数量多的话用insert
select方法插入,如果只是纯数字的话,可回以用系统答表
insert
into
tb
(a,b)
select
a.number,b.number
from
master..spt_values
a,master..spt_values
b
where
a.type='p'
and
b.type='p'
and
a.number
between
1
and
100
and
b.number
between
1
and
5