{"id":1811,"date":"2015-01-05T19:27:17","date_gmt":"2015-01-05T17:27:17","guid":{"rendered":"http:\/\/soci.hu\/blog\/?p=1811"},"modified":"2015-01-05T19:41:29","modified_gmt":"2015-01-05T17:41:29","slug":"sql-fejtoro-2-2","status":"publish","type":"post","link":"https:\/\/soci.hu\/blog\/index.php\/2015\/01\/05\/sql-fejtoro-2-2\/","title":{"rendered":"SQL fejt\u00f6r\u0151 2."},"content":{"rendered":"

Az al\u00e1bbi p\u00e9lda 1 sornyi \u00e9s 1 oszlopnyi eredm\u00e9nyhalmazt ad vissza, amiben NULL tal\u00e1lhat\u00f3. A feladat, hogy a k\u00f6z\u00e9pre be kellene \u00edrni egy darab sql k\u00f3dot, amit\u0151l k\u00e9t null j\u00f6n vissza 1 helyett.<\/p>\n

\r\nUSE TempDB\r\nGO\r\n\r\nCREATE TABLE AlmaTabla (Oszlop1 INT NULL)\r\nCREATE TABLE KorteTabla (Oszlop1 INT NULL)\r\nGO\r\nALTER TABLE AlmaTabla ADD CONSTRAINT\r\nUX_AlmaTabla UNIQUE NONCLUSTERED (Oszlop1);\r\nALTER TABLE KorteTabla ADD CONSTRAINT\r\nUX_KorteTabla UNIQUE NONCLUSTERED (Oszlop1);\r\nGO\r\nINSERT INTO AlmaTabla (Oszlop1)\r\nVALUES (NULL)\r\nGO\r\nINSERT INTO KorteTabla (Oszlop1)\r\nVALUES (NULL)\r\nGO\r\n\r\n--------------------------------------\r\n-- Ide kellene valamit beirni, hogy 2 NULL-os sor jojjon vissza\r\n--------------------------------------\r\n\r\nSELECT st.Oszlop1\r\nFROM AlmaTabla ft\r\nLEFT JOIN KorteTabla st ON st.Oszlop1 = ft.Oszlop1\r\nGO\r\n\r\nDROP TABLE AlmaTabla;\r\nDROP TABLE KorteTabla;\r\nGO\r\n<\/pre>\n
Kommenteket most se engedek ki, hogy mindenki gondolkodhasson, csak szerd\u00e1n, addig j\u00f6hetnek a megold\u00e1sok. :)<\/p>\n
A Test Driven Development tanfolyam<\/a> k\u00f6vetkez\u0151 felvon\u00e1sa febru\u00e1r 9-edik\u00e9n lesz, szeretettel v\u00e1rlak.<\/p>\n","protected":false},"excerpt":{"rendered":"
Az al\u00e1bbi p\u00e9lda 1 sornyi \u00e9s 1 oszlopnyi eredm\u00e9nyhalmazt ad vissza, amiben NULL tal\u00e1lhat\u00f3. A feladat, hogy a k\u00f6z\u00e9pre be kellene \u00edrni…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,4,30],"tags":[],"class_list":["post-1811","post","type-post","status-publish","format-standard","hentry","category-adatbazisok","category-szakmai-elet","category-sql-server"],"_links":{"self":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1811","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=1811"}],"version-history":[{"count":4,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1811\/revisions"}],"predecessor-version":[{"id":1820,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1811\/revisions\/1820"}],"wp:attachment":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=1811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=1811"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=1811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}