declare @Xml xml set @Xml=N'<es><e EcgID="0cef0895-de0e-4978-9470-46ac194aea43" Compressed="asasf" CompressedLen="74249" Ratio="0.520362752037677" CompressSpeed="87" DecompressSpeed="105" /></es>' SELECT M.a.value('@EcgID', 'uniqueidentifier') AS ecgID, M.a.value('@Compressed', 'varchar(max)') AS compressed, M.a.value('@CompressedLen', 'int') AS compressedLen, M.a.value('@Ratio', 'float') AS ratio, M.a.value('@CompressSpeed', 'float') AS compressSpeed, M.a.value('@DecompressSpeed', 'float') AS decompressSpeed FROM @XML.nodes('/es/e') M(a)
declare @Xml xml
set @Xml=N'<es><e EcgID="0cef0895-de0e-4978-9470-46ac194aea43" Compressed="asasf" CompressedLen="74249" Ratio="0.520362752037677" CompressSpeed="87" DecompressSpeed="105" /></es>'
SELECT M.a.value('@EcgID', 'uniqueidentifier') AS ecgID,
M.a.value('@Compressed', 'varchar(max)') AS compressed,
M.a.value('@CompressedLen', 'int') AS compressedLen,
M.a.value('@Ratio', 'float') AS ratio,
M.a.value('@CompressSpeed', 'float') AS compressSpeed,
M.a.value('@DecompressSpeed', 'float') AS decompressSpeed
FROM @XML.nodes('/es/e') M(a)
xml中 属性的大小写
一定要和@字段的
一模一样,不然获取的值为空。