{"id":642,"date":"2008-10-06T11:10:46","date_gmt":"2008-10-06T10:10:46","guid":{"rendered":"http:\/\/soci.hu\/blog\/?p=642"},"modified":"2008-10-06T11:26:18","modified_gmt":"2008-10-06T10:26:18","slug":"sql-server-programming-hacks-100-list","status":"publish","type":"post","link":"https:\/\/soci.hu\/blog\/index.php\/2008\/10\/06\/sql-server-programming-hacks-100-list\/","title":{"rendered":"SQL Server Programming Hacks &#8211; 100+ List"},"content":{"rendered":"<p>A hack sz\u00f3t nem szeretem, mert valami k\u00f3k\u00e1nyol\u00e1s, t\u00e1kol\u00e1s jut r\u00f3la az eszembe, de ez a <a href=\"http:\/\/wiki.lessthandot.com\/index.php\/SQL_Server_Programming_Hacks_-_100%2B_List\">site<\/a> meg\u00e9r egy mis\u00e9t. Sok-sok hasznos tipp van rajta, sql programol\u00f3knak.<br \/>\nPl. n\u00e9zz\u00fck <a href=\"http:\/\/wiki.lessthandot.com\/index.php\/NOT_IN_and_NULLs\">ezt<\/a>. Nagyon ravasz eset, ami b\u00e1rki belefuthat, ha egyszer csak megjelenik NULL valamelyik oszlopban, \u00e9s beborul a lek\u00e9rdez\u00e9s t\u0151le.<br \/>\nSajnos enn\u00e9l p\u00e9ld\u00e1ul nem \u00edrj\u00e1k le, milyen logika miatt nem az az eredm\u00e9ny j\u00f6n vissza, amit elv\u00e1runk, de <a href=\"http:\/\/www.tobinharris.com\/2007\/7\/11\/select-aaaargh-where-pain-in-null\">itt<\/a> pl. van hozz\u00e1 n\u00e9mi ideol\u00f3gia.<br \/>\nHa \u00e9n kezd\u0151 vagy k\u00f6z\u00e9phalad\u00f3 sql programol\u00f3 lenn\u00e9k, minden nap elolvasn\u00e9k is kipr\u00f3b\u00e1ln\u00e9k egy cikket, sokat lehet bel\u0151l\u00fck tanulni. (\u00cdgy is el fogom, csak nem napi egyet, hanem egyszerre sokat, valamelyik \u00e9jszaka. :)<\/p>\n<p>Update: \u00e9rdemes feliratkozni a <a href=\"http:\/\/wiki.lessthandot.com\/index.php\/Special:WikiFeeds\/atom\/recentarticlechanges\">feedj\u00e9re<\/a>.<br \/>\nSajnos nem tal\u00e1ltam feedet, ami csak err\u0151l sz\u00f3lna, ebben m\u00e1s is benne van (mondjuk azok se rosszak, de szeretek c\u00e9lir\u00e1nyosan inf\u00f3kat olvasni.) Ha valaki tal\u00e1lna, k\u00e9rem jelezze.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A hack sz\u00f3t nem szeretem, mert valami k\u00f3k\u00e1nyol\u00e1s, t\u00e1kol\u00e1s jut r\u00f3la az eszembe, de ez a site meg\u00e9r egy mis\u00e9t. Sok-sok hasznos&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,4,30,21,58],"tags":[],"class_list":["post-642","post","type-post","status-publish","format-standard","hentry","category-adatbazisok","category-szakmai-elet","category-sql-server","category-sql-server-2005","category-sql-server-2008"],"_links":{"self":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/642","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=642"}],"version-history":[{"count":4,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/642\/revisions"}],"predecessor-version":[{"id":644,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/642\/revisions\/644"}],"wp:attachment":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}