Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @MyXML XML
- SET @MyXML = '<SampleXML>
- <Colors>
- <Color1>White</Color1>
- <Color2>Blue</Color2>
- <Color3>Black</Color3>
- <Color4>Green</Color4>
- <Color5>Red</Color5>
- </Colors>
- <Fruits>
- <Fruits1>Apple</Fruits1>
- <Fruits2>Pineapple</Fruits2>
- <Fruits3>Grapes</Fruits3>
- <Fruits4>Melon</Fruits4>
- </Fruits>
- </SampleXML>'
- 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'
- set @MyXML.modify('
- insert text{"text"}
- as first into (/SampleXML)[1]
- ');
- SELECT @MyXML;
Add Comment
Please, Sign In to add comment