dc：从XML到SQL表的创建者-dc:creatorfromXMLintoSQLtable

0  

In your case it might be enough to replace the dc: with a wildcard: *:. Assuming your XML is written into an XML file already, you might try as such:

在您的情况下，用通配符替换dc：可能就足够了：*：假设您的XML已经写入XML文件，您可以尝试这样做：

DECLARE @xmlFile XML=
N'
  
    
    http://talksport.com/rss/sports-news/football/feed
    
    en
    
    
      
      http://talksport.com/football/hillsborough-families-back-introduction-rail-seating-bereaved-family-says-standing-did-not
      
      Wed, 19 Jul 2017 08:18:37 +0000
      talkSPORT
      247276 at http://talksport.com
    
  
';

SELECT
         title = t.value ('title[1]', 'NVARCHAR(300)'),
         link = t.value ('link[1]', 'NVARCHAR(300)'),
         source = t.value('(*:creator)[1]','NVARCHAR(30)')
FROM @XmlFile.nodes('/rss/channel/item') AS xTable(t);

This will work too:

这也可以：

WITH XMLNAMESPACES('http://purl.org/dc/elements/1.1/' AS dc)
SELECT
         title = t.value ('title[1]', 'NVARCHAR(300)'),
         link = t.value ('link[1]', 'NVARCHAR(300)'),
         source = t.value('(dc:creator)[1]','NVARCHAR(30)')
FROM @XmlFile.nodes('/rss/channel/item') AS xTable(t);

And you can declare the namespace within .value too:

您也可以在.value中声明命名空间：

SELECT
         title = t.value ('title[1]', 'NVARCHAR(300)'),
         link = t.value ('link[1]', 'NVARCHAR(300)'),
         source = t.value('declare namespace dc="http://purl.org/dc/elements/1.1/";(dc:creator)[1]','NVARCHAR(30)')
FROM @XmlFile.nodes('/rss/channel/item') AS xTable(t);