{"id":61,"date":"2013-05-31T12:33:00","date_gmt":"2013-05-31T17:33:00","guid":{"rendered":"https:\/\/www.chrystalsander.com\/blog\/?p=61"},"modified":"2023-07-27T12:04:00","modified_gmt":"2023-07-27T17:04:00","slug":"sql-simple-xquery-using-nodes","status":"publish","type":"post","link":"https:\/\/www.chrystalsander.com\/blog\/?p=61","title":{"rendered":"SQL : Simple XQuery Using .Nodes()"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>DECLARE @xml as XML;&nbsp;\n\nSELECT @xml = xmlField\n\nFrom YourTable\nWhere\nXmlId = '855041E\u2019;\n\nSELECT\nX.value('OrderId&#91;1]', 'VARCHAR(25)') As &#91;orderid],\nX.value('Status&#91;1]', 'VARCHAR(10)') As &#91;status]\nFROM @xml.nodes('head\/body\/response\/orders\/order') AS T(X);<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[50],"_links":{"self":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/61"}],"collection":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=61"}],"version-history":[{"count":2,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/61\/revisions"}],"predecessor-version":[{"id":268,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/61\/revisions\/268"}],"wp:attachment":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=61"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=61"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=61"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}