SQL Server - 包含 FOR XML 要求的无效 XML 标识符；

2021-10-01 00:00:00 xml sql sql-server

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

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

相关文章