{"id":19,"date":"2010-11-14T12:04:06","date_gmt":"2010-11-14T12:04:06","guid":{"rendered":"http:\/\/www.krmitblog.com\/?p=19"},"modified":"2024-04-01T18:16:33","modified_gmt":"2024-04-01T18:16:33","slug":"create-xml-file-from-sql-data","status":"publish","type":"post","link":"https:\/\/krmitblog.com\/?p=19","title":{"rendered":"Create XML file from SQL Data"},"content":{"rendered":"<p>Thanks to an article on SQLAuthority.com I found a quick and easy way to create an XML file from data in a sql database.&nbsp; I adapted his article and came up with this example.<\/p>\n<p>select ( Select * from table for XML PATH(&#8216;SAMPLEXML&#8217;),<br \/>\nTYPE<br \/>\n)<br \/>\nForm XML Path(&#8221;),<br \/>\nRoot(&#8216;XMLNODENAME&#8217;)<br \/>\nGo<\/p>\n<div class=\"signature\">\r\n<img decoding=\"async\" src=\"http:\/\/krmitblog.com\/wp-content\/uploads\/2013\/02\/krmsig1.png\" alt=\"signature\" \/>\r\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Thanks to an article on SQLAuthority.com I found a quick and easy way to create an XML file from data in a sql database.&nbsp; I adapted his article and came up with this example. select ( Select * from table for XML PATH(&#8216;SAMPLEXML&#8217;), TYPE ) Form XML Path(&#8221;), Root(&#8216;XMLNODENAME&#8217;) Go<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/krmitblog.com\/index.php?rest_route=\/wp\/v2\/posts\/19"}],"collection":[{"href":"https:\/\/krmitblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/krmitblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/krmitblog.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/krmitblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19"}],"version-history":[{"count":1,"href":"https:\/\/krmitblog.com\/index.php?rest_route=\/wp\/v2\/posts\/19\/revisions"}],"predecessor-version":[{"id":133,"href":"https:\/\/krmitblog.com\/index.php?rest_route=\/wp\/v2\/posts\/19\/revisions\/133"}],"wp:attachment":[{"href":"https:\/\/krmitblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/krmitblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/krmitblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}