照片无法显示, 代码如下: DECLARE @xml XML select @xml = CAST(bulkcolumn AS XML) FROM OPENROWSET(BULK 'E:\content.xml',SINGLE_BLOB)AS x SELECT x.value('@id','varchar(10)') AS id, x.value('@article','nvarchar(max)') AS article, x.value('@discuss','int') AS discuss, x.value('@insertTime','datetime') AS insertTime, x.value('@origin','nvarchar(50)') AS origin, x.value('@person_id','nchar(10)') AS person_id, x.value('@time','datetime') AS time, x.value('@transmit','int') AS transmit FROM @xml.nodes('/RECORDS/RECORD') i(x)错误如下: 消息 9448,级别 16,状态 1,第 2 行 XML 分析: 行 3735,字符 71,格式检查: 未声明的实体想请问下,未声明的实体是什么?x我有声明呀
代码如下:
DECLARE @xml XML
select
@xml = CAST(bulkcolumn AS XML)
FROM OPENROWSET(BULK 'E:\content.xml',SINGLE_BLOB)AS x
SELECT
x.value('@id','varchar(10)') AS id,
x.value('@article','nvarchar(max)') AS article,
x.value('@discuss','int') AS discuss,
x.value('@insertTime','datetime') AS insertTime,
x.value('@origin','nvarchar(50)') AS origin,
x.value('@person_id','nchar(10)') AS person_id,
x.value('@time','datetime') AS time,
x.value('@transmit','int') AS transmit
FROM @xml.nodes('/RECORDS/RECORD') i(x)错误如下:
消息 9448,级别 16,状态 1,第 2 行
XML 分析: 行 3735,字符 71,格式检查: 未声明的实体想请问下,未声明的实体是什么?x我有声明呀