{"id":543,"date":"2007-04-25T21:28:48","date_gmt":"2007-04-25T19:28:48","guid":{"rendered":"http:\/\/www.glorf.it\/blog\/2007\/04\/25\/sql-talk\/celko-des-tages"},"modified":"2007-04-25T21:28:48","modified_gmt":"2007-04-25T19:28:48","slug":"celko-des-tages","status":"publish","type":"post","link":"http:\/\/www.glorf.it\/blog\/2007\/04\/25\/sql-talk\/celko-des-tages","title":{"rendered":"Celko des Tages"},"content":{"rendered":"<p>In dem Posting &quot;<a href=\"http:\/\/joecelkothesqlapprentice.blogspot.com\/2007\/04\/dynamically-change-column-name-when.html\">Joe Celko The SQL Apprentice: dynamically change column name when displaying<\/a>&quot; wird ein SQL-Newbie zitiert. Da l&#228;uft es einem kalt den R&#252;cken runter. Die Antwort von Joe Celko ist einfach nur gro&#223;artig!<\/p>\n<blockquote><p> You have missed the ENTIRE CONCEPT OF A TIERED ARCHITECTURE!!<\/p>\n<p>You NEVER query a table for display; you query a table for **data** and the front end does their display.  You are writing 1950&#x0027;s file systems in SQL!!<\/p><\/blockquote>\n<p>Joe, du hast recht! Danke!<\/p>\n<p><a href=\"http:\/\/joecelkothesqlapprentice.blogspot.com\/2007\/04\/dynamically-change-column-name-when.html\"><br \/>\n<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In dem Posting &quot;Joe Celko The SQL Apprentice: dynamically change column name when displaying&quot; wird ein SQL-Newbie zitiert. Da l&#228;uft es einem kalt den R&#252;cken runter. Die Antwort von Joe Celko ist einfach nur gro&#223;artig! You have missed the ENTIRE CONCEPT OF A TIERED ARCHITECTURE!! You NEVER query a table for display; you query a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"_links":{"self":[{"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/posts\/543"}],"collection":[{"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/comments?post=543"}],"version-history":[{"count":0,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/posts\/543\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/media?parent=543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/categories?post=543"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/tags?post=543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}