如何用一条SQL语句实现一次插入多条记录?

[suasalito]

帮帮我,谢谢了.

[hanxian]

insert into table1(a) select a from table2

[DJMPH]

sp_executesql N'insert XX (XX) values ('1');insert XX (XX) values ('2');insert XX (XX) values ('3');.........'

[流星尔]

insert tablename select fieldname1,fieldname2 from sourcetablename
where clause

[OpenVMS]

insert into t select * from #t
:-)