如何避免链接服务器中的Xml数据类型问题？ [英] How to avoid Xml Data Type Issues in Linked Server?

问题描述

如何避免链接服务器中的Xml数据类型问题？

分布式查询中不支持Xml数据类型。远程对象'OPENQUERY'有xml列。

我尝试使用Open Query如下：

  INSERT   INTO   OPENQUERY （[TEST ]，'  SELECT Cast（EmailIds as Xml）as EmailIds FROM FTS_DIB_16062014_ITT.dbo.CustomerDetails'）（EmailIds ）
  SELECT  Cast（EmailIds  as   Varchar ） as  EmailIds  FROM  dbo.CustomerDetails 

解决方案

也许最简单的方法是将XML数据转换为NVARCHAR而不是不支持的XML。如果原始数据不是XML格式，那么不要尝试将其强制为XML。



XML在分布式查询中有点痛苦，因为你无法使用它好吧。



对此处 [ ^ ]

How to avoid Xml Data Type Issues in Linked Server?
Xml data type is not supported in distributed queries. Remote object 'OPENQUERY' has xml column(s).
I tried using Open Query as below:

INSERT INTO OPENQUERY([TEST],'SELECT Cast(EmailIds as Xml) as EmailIds FROM  FTS_DIB_16062014_ITT.dbo.CustomerDetails')(EmailIds)
SELECT Cast(EmailIds as Varchar) as EmailIds FROM  dbo.CustomerDetails

解决方案

Perhaps the easiest way could be to cast the XML data as NVARCHAR instead of XML which is not supported. If the original data is not in XML format then don't try force it to XML.

XML is a bit of a pain in distributed queries since you cannot use it at all.

There's a quite good discussion over here[^]

这篇关于如何避免链接服务器中的Xml数据类型问题？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！