用Sql server一次插入多条数据

可以将多条数据组成一棵XML树

　　将XML树作为varchar参数传入

　　用 insert xx select xxx from openxml() 的语法插入数据

　　一个小例子:

declare @ssss as nvarchar(2000) ;

set @ssss = N'

' ;

declare @idHandle as int ;

EXEC sp_xml_preparedocument @idHandle OUTPUT, @ssss

insert into tbl(Name,Intro)

select * from openxml(@idHandle,N'/root/dbo.tbl')

with dbo.tbl

EXEC sp_xml_removedocument @idHandle

(e129)