Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <Test foo="bar">
- <Otherstuff baz="belch" />
- </Test>
- select cast( '<Test foo="bar"><Otherstuff baz="belch" /></Test>' as xml).value('@foo','varchar(20)') as Foo
- declare @Data XML
- set @Data = '<Test foo="bar"><Otherstuff baz="belch" /></Test>'
- select @Data.value('(/Test/@foo)[1]','varchar(20)') as Foo
Add Comment
Please, Sign In to add comment