从图像字段 Sql Server 读取 Xml 字段

发布于 2025-01-09 13:25:39 字数 321 浏览 1 评论 0原文

我正在尝试更改下面的代码并从图像字段读取

        DECLARE @xml XML
        SELECT @xml= x FROM OPENROWSET (BULK ''' + @XMLFILE + ''', SINGLE_BLOB) AS T(x)

它如何转换为 Xml 类型？

SELECT @xml= FileField FROM FileListTable (FileField is İmage Field)

原文

I am trying to change the code below and read it from the image field

        DECLARE @xml XML
        SELECT @xml= x FROM OPENROWSET (BULK ''' + @XMLFILE + ''', SINGLE_BLOB) AS T(x)

How Can I Convert To Xml Type?

SELECT @xml= FileField FROM FileListTable (FileField is İmage Field)

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

失而复得 2025-01-16 13:25:39

尝试：

SELECT @xml = CAST(CAST(FileField AS VARBINARY(MAX)) AS XML)
FROM FileListTable

这是否有效，可能取决于 XML 在插入表之前如何转换为 IMAGE 数据类型。此 db<>fiddle 练习将 XML 插入 IMAGE 列的各种方法，以及有几种方法（好的和坏的）试图把它弄出来。几乎令人惊讶的是，先转换为 VARBINARY(MAX)，然后转换为 XML 似乎可以处理所演示的情况。

Try:

SELECT @xml = CAST(CAST(FileField AS VARBINARY(MAX)) AS XML)
FROM FileListTable

Whether this works or not, may depend on how the XML was converted to the IMAGE data type before being inserted into your table. This db<>fiddle exercises various ways of inserting XML into an IMAGE column and several ways (both good and bad) to try to get it out. Almost surprisingly, the cast to VARBINARY(MAX) and then to XML seems to handle the cases demonstrated.

回复收藏 0 原文

~没有更多了~