本文介绍了SQL Server - 包含 FOR XML 要求的无效 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 标识符；的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！
本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益，请联系我们，我们会在确认后第一时间进行删除！