22,209
社区成员
发帖
与我相关
我的任务
分享
DECLARE @Xml XML
SET @Xml='<N>a & b</N>'
DECLARE @docHandle int
EXEC sp_xml_preparedocument @docHandle OUTPUT,@Xml
SELECT * FROM OPENXML(@docHandle,'/',2) WITH (N varchar(100))
EXEC sp_xml_removedocument @docHandle
Msg 9421, Level 16, State 1, Line 2
XML parsing: line 1, character 7, illegal name character
select *
from
(SELECT '&' COL) t
FOR xml auto
/*
<t COL="&"/>
(1 個資料列受到影響)
*/
DECLARE @Xml XML
SET @Xml='<N>a & b</N>'
DECLARE @docHandle int
EXEC sp_xml_preparedocument @docHandle OUTPUT,@Xml
SELECT * FROM OPENXML(@docHandle,'/',2) WITH (N varchar(100))
EXEC sp_xml_removedocument @docHandle
--结果
N
----------------------------------------------------------------------------------------------------
a & b
(1 行受影响)