SQL Server - 包含 FOR XML 要求的无效 XML 标识符； [英] SQL Server - contains an invalid XML identifier as required by FOR XML;

问题描述

我正在运行此查询并遇到以下提到的错误.有人可以帮忙吗?

I'm running this query and getting below mentioned error. Can anyone help?

列名中间名"包含无效的 XML 标识符对于 XML；' '(0x0020) 是第一个出错的字符.

Column name 'Middle Name' contains an invalid XML identifier as required by FOR XML; ' '(0x0020) is the first character at fault.

SELECT 
    Username as [LastName],
    '' AS [Middle Name],
    '' AS Birthdate,
    '' AS [SSN],
    0 AS [Wage Amount]
    FROM
    Employee
     FOR XML PATH

推荐答案

XML 元素或属性名称中不能有空格.使用

You can't have spaces in XML element or attribute names. Use

SELECT Username AS [LastName],
       ''       AS [MiddleName],
       ''       AS Birthdate,
       ''       AS [SSN],
       0        AS [WageAmount]
FROM   Employee
FOR XML PATH 

这篇关于SQL Server - 包含 FOR XML 要求的无效 XML 标识符；的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！