11,849
社区成员
发帖
与我相关
我的任务
分享
DECLARE @x XML
SET @x='<Root Col1=''A'' Col2="A"/>'
SELECT @x
/*
<Root Col1="A" Col2="A" />
*/
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Data Center Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)
DECLARE @x XML
SET @x='<Root Col1=''A'' Col2="A"/>'
select @x
--消息 9455,级别 16,状态 1,第 2 行
--XML 分析: 行 1,字符 6,非法的限定名称字符
SELECT @@VERSION
--Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
--Apr 2 2010 15:48:46
--Copyright (c) Microsoft Corporation Enterprise Edition (64-bit)
--on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)