Guest User

Untitled

a guest
Jun 22nd, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. <Test foo="bar">
  2. <Otherstuff baz="belch" />
  3. </Test>
  4.  
  5. select cast( '<Test foo="bar"><Otherstuff baz="belch" /></Test>' as xml).value('@foo','varchar(20)') as Foo
  6.  
  7. declare @Data XML
  8. set @Data = '<Test foo="bar"><Otherstuff baz="belch" /></Test>'
  9.  
  10. select @Data.value('(/Test/@foo)[1]','varchar(20)') as Foo
Add Comment
Please, Sign In to add comment