{"id":3726,"date":"2014-11-12T17:35:11","date_gmt":"2014-11-12T08:35:11","guid":{"rendered":"http:\/\/auctionpro.co.kr\/?p=3726"},"modified":"2014-11-12T18:04:50","modified_gmt":"2014-11-12T09:04:50","slug":"ms-slq-%ed%85%8c%ec%9d%b4%eb%b8%94-%ec%bb%ac%eb%9f%bc%eb%b9%84%ea%b5%90-except","status":"publish","type":"post","link":"https:\/\/www.auctionpro.co.kr\/?p=3726","title":{"rendered":"[ms slq] \ud14c\uc774\ube14 \uceec\ub7fc\ube44\uad50 EXCEPT(\ucc28\uc9d1\ud569) INTERSECT(\uad50\uc9d1\ud569)"},"content":{"rendered":"<p>\ucc38\uc870 : <a href=\"https:\/\/www.simple-talk.com\/sql\/performance\/the-except-and-intersect-operators-in-sql-server\/\" target=\"_blank\">https:\/\/www.simple-talk.com\/sql\/performance\/the-except-and-intersect-operators-in-sql-server\/<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3728\" src=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2014\/11\/Lunch_Dinner.jpg\" alt=\"Lunch_Dinner\" width=\"501\" height=\"642\" srcset=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2014\/11\/Lunch_Dinner.jpg 501w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2014\/11\/Lunch_Dinner-234x300.jpg 234w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2014\/11\/Lunch_Dinner-117x150.jpg 117w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2014\/11\/Lunch_Dinner-400x512.jpg 400w\" sizes=\"auto, (max-width: 501px) 100vw, 501px\" \/><br \/>\nEXCEPT(\ucc28\uc9d1\ud569)<br \/>\n<a href=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2014\/11\/Lunch_Dinner02.jpg\"><br \/>\n<\/a><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3729\" src=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2014\/11\/Lunch_Dinner02.jpg\" alt=\"Lunch_Dinner02\" width=\"515\" height=\"613\" srcset=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2014\/11\/Lunch_Dinner02.jpg 515w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2014\/11\/Lunch_Dinner02-252x300.jpg 252w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2014\/11\/Lunch_Dinner02-126x150.jpg 126w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2014\/11\/Lunch_Dinner02-400x476.jpg 400w\" sizes=\"auto, (max-width: 515px) 100vw, 515px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>INTERSECT(\uad50\uc9d1\ud569)<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3741\" src=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2014\/11\/INTERSECT.jpg\" alt=\"INTERSECT\" width=\"529\" height=\"460\" srcset=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2014\/11\/INTERSECT.jpg 529w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2014\/11\/INTERSECT-300x260.jpg 300w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2014\/11\/INTERSECT-150x130.jpg 150w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2014\/11\/INTERSECT-400x347.jpg 400w\" sizes=\"auto, (max-width: 529px) 100vw, 529px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>\ucc38\uc870 : https:\/\/www.simple-talk.com\/sql\/performance\/the-except-and-intersect-operators-in-sql-server\/ EXCEPT(\ucc28\uc9d1\ud569) &nbsp; INTERSECT(\uad50\uc9d1\ud569)<\/p>\n<\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[16],"tags":[],"class_list":["post-3726","post","type-post","status-publish","format-standard","hentry","category-mssql-server"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/3726","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3726"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/3726\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3726"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3726"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3726"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}