可以将多条数据组成一棵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.tb...
[ 查看全文 ]