【可以将多条数据组成一棵XML树 将XML...... 可以将多条数据组成一棵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 (好像不能用临时表.不管先了.先用着..以后再找些资料看看) |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-30 11:39 , Processed in 0.124807 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.