My Blog List

hotinit.com. Powered by Blogger.

Search This Blog

Read Values of xml through tsql or sql querry

Monday, 19 September 2011






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

 

Blogger news

Blogroll

Most Reading

8.6/10