{"id":8119,"date":"2019-01-17T20:34:27","date_gmt":"2019-01-17T20:34:27","guid":{"rendered":"https:\/\/dbtut.com\/?p=8119"},"modified":"2019-01-18T09:25:46","modified_gmt":"2019-01-18T09:25:46","slug":"except-operator-in-sql-servertsql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/","title":{"rendered":"EXCEPT Operator in SQL Server(TSQL)"},"content":{"rendered":"<p><img decoding=\"async\" class=\"alignleft\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c40e5021b4b0.png\" alt=\"\" \/><\/p>\n<p>We can use the SQL EXCEPT Operator between two SQL Statement. It allows us to return records that exist in the first SQL Statement, but not in the second SQL Statement. This allows TSQL code developers to simplify their work in some cases.<\/p>\n<p>In the two SQL Statement, where the EXCEPT operator is used, matching columns must have the same data type. For example, if the first column of the first Select Statement is int, the first column of the second SQL Statement must be int.<\/p>\n<p>In fact, even if the data type is not the same, we can run the query without any errors between the data types that are compatible with each other. For example, varchar and nchar are compatible data types. or int and small int.<\/p>\n<p><strong>Example:<\/strong><\/p>\n<p>First, we create two tables and we add a few records to these tables.<\/p>\n<pre class=\"lang:default decode:true\">USE [TestDB]\nGO\nCREATE TABLE [dbo].[MyTable1](\n[ID] [int] IDENTITY(1,1) NOT NULL,\n[Name] [varchar](50) NULL\n) ON [PRIMARY]\nGO\nCREATE TABLE [dbo].[MyTable2](\n[ID] [int] IDENTITY(1,1) NOT NULL,\n[Name] [varchar](50) NULL\n) ON [PRIMARY]\nGO\nINSERT INTO [dbo].[MyTable1] VALUES ('Nurullah CAKIR'),('Faruk ERDEM')\nINSERT INTO [dbo].[MyTable2] VALUES ('Nurullah CAKIR'),('Faruk ER'),('Hakan GURBASLAR')<\/pre>\n<p>Then, using the EXCEPT operator, we find the records in the first table but not in the second table..<\/p>\n<pre class=\"lang:default decode:true\">SELECT Name FROM [dbo].[MyTable1]\nEXCEPT\nSELECT Name FROM [dbo].[MyTable2]<\/pre>\n<p id=\"alkxSgL\"><img loading=\"lazy\" decoding=\"async\" width=\"458\" height=\"226\" class=\"size-full wp-image-8124  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c40e5794195d.png\" alt=\"\" \/><\/p>\n<p>If the column numbers in the two SQL Statement are different, you will get an error as follows.<\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\"><em>Msg 205, Level 16, State 1, Line 1<\/em><\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\"><em>All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.<\/em><\/p>\n<p id=\"LnZGApM\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-8126  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c40e5a72b0dc.png\" alt=\"\" width=\"659\" height=\"139\" \/><\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\">Let&#8217;s detail our example a little more. Let&#8217;s add a column named typeofint to both tables by running the following script. One of the column&#8217;s type is varchar (50), the other column&#8217;s type is int. And let&#8217;s update two tables as follows.<\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\">\n<pre class=\"lang:default decode:true\">ALTER TABLE MyTable1 ADD [typeofint] varchar(50) NULL\nALTER TABLE MyTable2 ADD [typeofint] int NULL\n\nUPDATE MyTable1 SET [typeofint]='A' WHERE ID=1\nUPDATE MyTable1 SET [typeofint]='B' WHERE ID=2\n\nUPDATE MyTable2 SET [typeofint]=1 WHERE ID=1\nUPDATE MyTable2 SET [typeofint]=2 WHERE ID=2\nUPDATE MyTable2 SET [typeofint]=3 WHERE ID=3<\/pre>\n<p><strong>Rewrite the EXCEPT query as follows:<\/strong><\/p>\n<pre class=\"lang:default decode:true\">SELECT typeofint FROM [dbo].[MyTable1] \nEXCEPT \nSELECT typeofint FROM [dbo].[MyTable2]<\/pre>\n<p>Although the names of the two columns are the same, we will get the error as follows because the data types are different.<\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\"><em>Msg 245, Level 16, State 1, Line 1<\/em><\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\"><em>Conversion failed when converting the varchar value &#8216;A&#8217; to data type int.<\/em><\/p>\n<p id=\"RzOcjPC\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-8128  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c40e62bdcd47.png\" alt=\"\" width=\"582\" height=\"214\" \/><\/p>\n<p>This time we will add two columns of the same data type with different names and update these columns with some data.<\/p>\n<pre class=\"lang:default decode:true\">ALTER TABLE MyTable1 ADD [testcolumn1] varchar(50) NULL\nALTER TABLE MyTable2 ADD [testcolumn2] varchar(50) NULL\n\nUPDATE MyTable1 SET [testcolumn1]='A' WHERE ID=1\nUPDATE MyTable1 SET [testcolumn1]='B' WHERE ID=2\n\nUPDATE MyTable2 SET [testcolumn2]='A' WHERE ID=1\nUPDATE MyTable2 SET [testcolumn2]='C' WHERE ID=2\nUPDATE MyTable2 SET [testcolumn2]='D' WHERE ID=3\n\n<\/pre>\n<p><strong>Rewrite the EXCEPT query as follows:<\/strong><\/p>\n<pre class=\"lang:default decode:true\">SELECT testcolumn1 FROM [dbo].[MyTable1]\nEXCEPT\nSELECT testcolumn2 FROM [dbo].[MyTable2]<\/pre>\n<p>As you can see, although the names are different, we did not receive any errors because the data types are the same.<\/p>\n<p id=\"iBMxBqo\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-8130  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c40e6819b1e8.png\" alt=\"\" width=\"477\" height=\"183\" \/><\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_8119\" class=\"pvc_stats all  \" data-element-id=\"8119\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>We can use the SQL EXCEPT Operator between two SQL Statement. It allows us to return records that exist in the first SQL Statement, but not in the second SQL Statement. This allows TSQL code developers to simplify their work in some cases. In the two SQL Statement, where the EXCEPT operator is used, matching &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_8119\" class=\"pvc_stats all  \" data-element-id=\"8119\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3,1596],"tags":[1692,1691],"class_list":["post-8119","post","type-post","status-publish","format-standard","","category-mssql","category-tsql","tag-except-operator-in-sql-server","tag-minus-opetar-in-sql-server"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>EXCEPT Operator in SQL Server(TSQL) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"EXCEPT Operator in SQL Server(TSQL)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"EXCEPT Operator in SQL Server(TSQL) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"EXCEPT Operator in SQL Server(TSQL)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-17T20:34:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-01-18T09:25:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c40e5021b4b0.png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"EXCEPT Operator in SQL Server(TSQL)\",\"datePublished\":\"2019-01-17T20:34:27+00:00\",\"dateModified\":\"2019-01-18T09:25:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/\"},\"wordCount\":351,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c40e5021b4b0.png\",\"keywords\":[\"EXCEPT Operator in SQL Server\",\"MINUS Opetar in SQL Server\"],\"articleSection\":[\"MSSQL\",\"TSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/\",\"name\":\"EXCEPT Operator in SQL Server(TSQL) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c40e5021b4b0.png\",\"datePublished\":\"2019-01-17T20:34:27+00:00\",\"dateModified\":\"2019-01-18T09:25:46+00:00\",\"description\":\"EXCEPT Operator in SQL Server(TSQL)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c40e5021b4b0.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c40e5021b4b0.png\",\"width\":353,\"height\":305},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"EXCEPT Operator in SQL Server(TSQL)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"EXCEPT Operator in SQL Server(TSQL) - Database Tutorials","description":"EXCEPT Operator in SQL Server(TSQL)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/","og_locale":"en_US","og_type":"article","og_title":"EXCEPT Operator in SQL Server(TSQL) - Database Tutorials","og_description":"EXCEPT Operator in SQL Server(TSQL)","og_url":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/","og_site_name":"Database Tutorials","article_published_time":"2019-01-17T20:34:27+00:00","article_modified_time":"2019-01-18T09:25:46+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c40e5021b4b0.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"EXCEPT Operator in SQL Server(TSQL)","datePublished":"2019-01-17T20:34:27+00:00","dateModified":"2019-01-18T09:25:46+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/"},"wordCount":351,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c40e5021b4b0.png","keywords":["EXCEPT Operator in SQL Server","MINUS Opetar in SQL Server"],"articleSection":["MSSQL","TSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/","url":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/","name":"EXCEPT Operator in SQL Server(TSQL) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c40e5021b4b0.png","datePublished":"2019-01-17T20:34:27+00:00","dateModified":"2019-01-18T09:25:46+00:00","description":"EXCEPT Operator in SQL Server(TSQL)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c40e5021b4b0.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c40e5021b4b0.png","width":353,"height":305},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/except-operator-in-sql-servertsql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"EXCEPT Operator in SQL Server(TSQL)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/8119","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=8119"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/8119\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=8119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=8119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=8119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}