如何一次插入多条纪录

[newneter]

insert into tablename (aa,bb,cc,dd) values(.............)
我想在values里面插入多条记录该怎么写呢？
谢谢

[newneter]

比方说
a1,a2,a3
b1,b2,b3
该怎么插

[CrazyFor]

insert into tablename (aa,bb,cc,dd)
select .....与上面一一对应 from 另一表

[newneter]

那我实际的a1,a2,a3,b1,b2,b3都是数组不是从表里面搜到的怎么办？
只能一条一条插么？

[caiyunxia]

insert into tablename
select top 10 'a1','a2','a3'
from sysobjects

[愉快的登山者]

insert into table1
select 'a1','a2','a3'
union all
select 'b1','b2','b3'
union all
......

或
insert into table1
select * from table2

[愉快的登山者]

insert into tablename (aa,bb,cc,dd)
select 'a1','a2','a3','a4'
union all
select 'b1','b2','b3','b4'
union all
select 'c1','c2','c3','c4'
union all
......