Insert xml to DB Column

 

declare @country xml
set @country =( select *
from openrowset(bulk 'D:\TEMP\country_iso.xml',single_clob) as xmldata
)
insert XMLData (RawXml) values
(@country )

posted @ 2012-04-27 19:53  mjg  阅读(130)  评论(0编辑  收藏  举报