Guest User

Untitled

a guest
Jun 22nd, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. DECLARE @MyXML XML
  2. SET @MyXML = '<SampleXML>
  3. <Colors>
  4. <Color1>White</Color1>
  5. <Color2>Blue</Color2>
  6. <Color3>Black</Color3>
  7. <Color4>Green</Color4>
  8. <Color5>Red</Color5>
  9. </Colors>
  10. <Fruits>
  11. <Fruits1>Apple</Fruits1>
  12. <Fruits2>Pineapple</Fruits2>
  13. <Fruits3>Grapes</Fruits3>
  14. <Fruits4>Melon</Fruits4>
  15. </Fruits>
  16. </SampleXML>'
  17.  
  18. result='<SampleXML>text<Colors>text<Color1>White</Color1>text<Color2>Blue</Color2>text<Color3>Black</Color3>text<Color4>Green</Color4>text <Color5>Red</Color5>text</Colors>text<Fruits>text<Fruits1>Apple</Fruits1>text<Fruits2>Pineapple</Fruits2>text<Fruits3>Grapes</Fruits3>text<Fruits4>Melon</Fruits4>text</Fruits>text</SampleXML>text'
  19.  
  20. set @MyXML.modify('
  21. insert text{"text"}
  22. as first into (/SampleXML)[1]
  23. ');
  24. SELECT @MyXML;
Add Comment
Please, Sign In to add comment