Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- Alias
- from OpenXml(@XML, '/Entity/Aliases', 2)
- with (
- Alias varchar(255) '.'
- )
- <Entity>
- <EntityID>123</EntityID>
- <Aliases>
- <Alias>TEST 1</Alias>
- </Aliases>
- <Aliases>
- <Alias>TEST 2</Alias>
- </Aliases>
- <Aliases>
- <Alias>TEST 3</Alias>
- </Aliases>
Add Comment
Please, Sign In to add comment