Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- declare @xml xml
- set @xml = '<root>
- <group Description="firstgroup">
- <nodeA age="10" birthplace="Anchorage"/>
- <nodeB mode="A" ability="read"/>
- </group>
- <group Description="nextgroup">
- <nodeA age="10" birthplace="London"/>
- <nodeB count="2" birthplace="Paris"/>
- </group>
- </root>'
- select
- c.value('@Description', 'varchar(max)') as 'Description'
- from @xml.nodes('/root/*') as T(c)
- select
- c.value('@Description', 'varchar(max)') as 'Description'
- , c.query('./nodeB') as Content
- from @xml.nodes('/root/*') as T(c)
- -- Results to:
- Description Content
- firstgroup <nodeB mode="A" ability="read" />
- nextgroup <nodeB count="2" birthplace="Paris" />
- Select c.value('@Description', 'varchar(max)') as 'Description'
- ,AsString = convert(varchar(max),c.query('./*[2]') )
- ,AsXML = c.query('./*[2]')
- From @xml.nodes('/root/*') as T(c)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement