阅读背景:

SQL Server 2008 R2:导出XML BLOB并作为表导回到SQL

来源:互联网 

I have a client application that generate a database into my SQL Server. The generated database contains a BLOB data (image data type) of an XML file. My question is how best would I be able to use and read the data inside the XML file (for generating a web report). Would it be possible to a good idea to export the BLOB data into an XML file on the disk and import the XML back into SQL as table database. If yes, how would I go about doing this? Would I be using BCP to export the BLOB out into XML file? Also is it possible to import the XML back without predetermining / pre-creating the columns in the table? Thanks!! I have a client application that generate a dat




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: