{"id":2130,"date":"2017-10-20T22:36:31","date_gmt":"2017-10-20T20:36:31","guid":{"rendered":"https:\/\/bob-team.de\/wordpress\/?p=2130"},"modified":"2017-10-20T22:43:43","modified_gmt":"2017-10-20T20:43:43","slug":"sql-abfrage-zu-xml-datei","status":"publish","type":"post","link":"https:\/\/bob-team.de\/wordpress\/2017\/10\/20\/sql-abfrage-zu-xml-datei\/","title":{"rendered":"SQL-Abfrage zu XML-Datei"},"content":{"rendered":"<p>Das t\u00e4gliche Abfrageergebnis als XML-Datei schreiben. Die Spalte &#8222;erstellt&#8220; enth\u00e4lt Datum und Uhrzeit von der Datensatzanlage.<\/p>\n<pre lang=\"dos\">@echo off\r\nset jahr=%date:~-2%\r\nset monat=%date:~-7,2%\r\nset tag=%date:~-10,2%\r\nbcp \"select t1.* \\\r\n  , convert(date, dateadd(day, -1, '%tag%.%monat%.%jahr%'), 104) as exportkey \\\r\n  from db..table t1 \\\r\n  where convert(date, [erstellt]) = dateadd(day, -1, '%tag%.%monat%.%jahr%') \\\r\n  order by [erstellt] desc \\\r\n  for xml auto, TYPE, ELEMENTS, ROOT('rows')\" \\\r\n  queryout c:\\Temp\\rows_%jahr%%monat%%tag%.xml -S (local) -T -w<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Das t\u00e4gliche Abfrageergebnis als XML-Datei schreiben. Die Spalte &#8222;erstellt&#8220; enth\u00e4lt Datum und Uhrzeit von der Datensatzanlage. @echo off set jahr=%date:~-2% set monat=%date:~-7,2% set tag=%date:~-10,2% bcp &#8222;select t1.* \\ , convert(date, dateadd(day, -1, &#8218;%tag%.%monat%.%jahr%&#8216;), 104) as exportkey \\ from db..table t1 \\ where convert(date, [erstellt]) = dateadd(day, -1, &#8218;%tag%.%monat%.%jahr%&#8216;) \\ order by [erstellt] desc \\ for [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2130","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"_links":{"self":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts\/2130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/comments?post=2130"}],"version-history":[{"count":3,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts\/2130\/revisions"}],"predecessor-version":[{"id":2134,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts\/2130\/revisions\/2134"}],"wp:attachment":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/media?parent=2130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/categories?post=2130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/tags?post=2130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}