http://sqlserver.ro/forums/22/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/431.aspxThu, 19 Oct 2006 07:56:49 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:431xmldeveloper0http://sqlserver.ro/forums/thread/431.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=22&PostID=431<p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:10pt;font-family:Arial;">XML Data Manipulation Language</span></strong><span style="font-size:10pt;font-family:Arial;"></span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:9pt;font-family:Arial;"></span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:9pt;font-family:Arial;">Limbajul <em>XQUERY</em> nu permite modificarea documentelor xml, pentru modificari folosindu-se o extensie a <em>XQUERY</em> &ndash; <em>XML DML</em> (XML Data Manipulation Language).</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:9pt;font-family:Arial;">Concret<span>&nbsp; </span><em>XML DML</em> extinde <em>XQUERY</em> cu urmatoarele instructiuni: </span></p><p class="MsoNormal" style="margin:0in 0in 0pt 0.25in;text-indent:-0.25in;tab-stops:list .25in;"><span style="font-size:9pt;font-family:Wingdings;"><span>&sect;<span style="font:7pt 'Times New Roman';">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><span style="font-size:9pt;font-family:Arial;">insert &ndash; pentru adaugare</span></p><p class="MsoNormal" style="margin:0in 0in 0pt 0.25in;text-indent:-0.25in;tab-stops:list .25in;"><span style="font-size:9pt;font-family:Wingdings;"><span>&sect;<span style="font:7pt 'Times New Roman';">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><span style="font-size:9pt;font-family:Arial;">delete &ndash; pentru stergere</span></p><p class="MsoNormal" style="margin:0in 0in 0pt 0.25in;text-indent:-0.25in;tab-stops:list .25in;"><span style="font-size:9pt;font-family:Wingdings;"><span>&sect;<span style="font:7pt 'Times New Roman';">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><span style="font-size:9pt;font-family:Arial;">replace value of &ndash; pentru modificare</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:9pt;font-family:Arial;">Instructiunile se pot folosi prin intermediul metodei <em>modify</em>.</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:9pt;font-family:Arial;"></span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:9pt;font-family:Arial;">Exemplu:</span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:8pt;font-family:'Courier New';">-- declarare si setare variabila tip xml</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:8pt;font-family:'Courier New';">DECLARE @myDoc XML</span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:8pt;font-family:'Courier New';">SELECT<span>&nbsp; </span>@myDoc = BulkColumn </span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:8pt;font-family:'Courier New';">FROM OPENROWSET( Bulk &#39;C:\Books.xml&#39;, SINGLE_BLOB ) AS x </span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:8pt;font-family:'Courier New';"></span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:8pt;font-family:'Courier New';">-- insereaza un element autor pentru al doilea</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:8pt;font-family:'Courier New';">-- element carte</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:8pt;font-family:'Courier New';">SET @myDoc.modify(&#39;<span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:8pt;font-family:'Courier New';">insert &lt;autor&gt;Karli Watson&lt;/autor&gt; </span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:8pt;font-family:'Courier New';">into (/magazin/carte/autori)[2]&#39;) </span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:8pt;font-family:'Courier New';">SELECT @myDoc</span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:10pt;font-family:Arial;"></span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;">&nbsp;</p>