DECLARE @doc xml ='<?xml
version="1.0"?>
<dicom>
<attr len="2" vr="OB"
tag="00020001">00\01</attr>
<attr len="22" vr="UI"
tag="00020002">1.2.840.10008.5.1.4.33</attr>
</dicom>'
declare @idoc int
select @doc
EXEC sp_xml_preparedocument @idoc
OUTPUT, @doc
SELECT
tag,len,comment
FROM
OPENXML(@idoc, '/dicom/attr')
WITH
(tag varchar(30)
,len varchar(30)
,comment ntext 'text()'
)
No comments:
Post a Comment