照片无法显示,
代码如下:
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)