{"id":7753,"date":"2019-01-14T21:21:23","date_gmt":"2019-01-14T21:21:23","guid":{"rendered":"https:\/\/dbtut.com\/?p=7753"},"modified":"2019-01-14T21:21:23","modified_gmt":"2019-01-14T21:21:23","slug":"union-and-union-all-operators-in-sql-servertsql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/","title":{"rendered":"UNION and UNION ALL Operators in SQL Server(TSQL)"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>With UNION and UNION ALL Opertors, we can merge multiple sql statement&#8217;s result in a single result set.<\/p>\n<p>When we merge two SQL statements with the UNION operator, duplicate records are listed once in the result set.<\/p>\n<p>When we merge two SQL statements with the UNION ALL operator, all results are listed.<\/p>\n<p>If there are no duplicate records in queries that we will merge with union or union all, UNION and UNION ALL will return the same result set. We will explain the difference in performance between them at the end of the article.<\/p>\n<p>UNION or UNION ALL operators are used when we need to merge multiple result sets in SQL Server. For example, let&#8217;s assume that the internet sales and the store sales are in different tables in a database. To list the total sales, a combination of these two tables is required. When using UNION and UNION ALL operators, the following points should be considered.<\/p>\n<ul>\n<li>The number of columns in all result sets must be the same.<\/li>\n<li>The data types of the columns corresponding to each other must match each other.<\/li>\n<\/ul>\n<p><strong>Examples about UNION and UNION ALL:<\/strong><\/p>\n<p>First, let&#8217;s create 2 sample tables.<\/p>\n<pre class=\"lang:default decode:true\">CREATE TABLE Test\r\n([ID] INT IDENTITY,\r\n\u00a0[Name] NVARCHAR(20),\r\n\u00a0[Surname] NVARCHAR(50),\r\n\u00a0[Date] DATE)\r\nINSERT Test\r\nVALUES ('Hakan','GURBASLAR','2017-01-01'),('Nurullah','CAKIR','2017-01-01'),('Faruk','ERDEM','2017-01-01')\r\n\r\nCREATE TABLE Test2\r\n([ID] INT IDENTITY,\r\n\u00a0[Name] NVARCHAR(20),\r\n\u00a0[Surname] NVARCHAR(50),\r\n\u00a0[Date] DATE)\r\nINSERT Test2\r\nVALUES ('Hakan','GURBASLAR','2015-01-01'),('Nurullah','CAKIR','2016-01-01'),('Faruk','ERDEM','2017-01-01')<\/pre>\n<p><strong>First, let&#8217;s see the difference between UNION and UNION ALL:<\/strong><\/p>\n<p><strong>UNION ALL:<\/strong><\/p>\n<pre class=\"lang:default decode:true\">SELECT [Name],[Surname]\r\nFROM Test\r\nUNION ALL\r\nSELECT [Name],[Surname]\r\nFROM Test2<\/pre>\n<p id=\"raBwfRR\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-7756  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c3cfb364ea0e.png\" alt=\"\" width=\"624\" height=\"341\" \/><\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\"><strong>UNION:<\/strong><\/p>\n<pre class=\"lang:default decode:true\">SELECT [Name],[Surname]\r\nFROM Test\r\nUNION\r\nSELECT [Name],[Surname]\r\nFROM Test2<\/pre>\n<p id=\"kAHODHY\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-7758  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c3cfb6fa219a.png\" alt=\"\" width=\"570\" height=\"316\" \/><\/p>\n<p>As seen in this example, when we use UNION, the recurring records are listed 1 times in the result set.<\/p>\n<p>When we try to merge two result sets with a different number of columns, we get an error as follows.<\/p>\n<pre class=\"lang:default decode:true\">SELECT [Name],[Surname],[ID]\r\nFROM Test\r\nUNION ALL\r\nSELECT [Name],[Surname]\r\nFROM Test2<\/pre>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\"><span style=\"font-style: italic;\">Msg 205, Level 16, State 1, Line 1<\/span><\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\"><span style=\"font-style: italic;\">All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.<\/span><\/p>\n<p id=\"lgykOTg\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-7760  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c3cfba83d98f.png\" alt=\"\" width=\"627\" height=\"167\" \/><\/p>\n<p>Let&#8217;s change the column order in Query. Because the data types are the same, we will not encounter any errors in UNION operation.<\/p>\n<pre class=\"lang:default decode:true\">SELECT [Surname],[Name]\r\nFROM Test\r\nUNION ALL\r\nSELECT [Name],[Surname]\r\nFROM Test2<\/pre>\n<p id=\"nEDDdYa\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-7762  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c3cfbdbca5a6.png\" alt=\"\" width=\"523\" height=\"380\" \/><\/p>\n<p>If we change the query as follows, we get an error when we run the query. Because the data types of the ID and Date columns do not match.<\/p>\n<pre class=\"lang:default decode:true\">SELECT [Name],[Surname],[ID]\r\nFROM Test\r\nUNION ALL\r\nSELECT [Name],[Surname],[Date]\r\nFROM Test2<\/pre>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\"><span style=\"font-style: italic;\">Msg 206, Level 16, State 2, Line 1<\/span><\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\"><span style=\"font-style: italic;\">Operand type clash: int is incompatible with date<\/span><\/p>\n<p id=\"PKQQZxJ\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-7764  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c3cfc0e44de7.png\" alt=\"\" width=\"510\" height=\"283\" \/><\/p>\n<p>Let&#8217;s run the UNION query by taking only the year parts of the date columns.<\/p>\n<pre class=\"lang:default decode:true\">SELECT [Name],[Surname],YEAR([Date])\r\nFROM Test\r\nUNION ALL\r\nSELECT [Name],[Surname],YEAR([Date])\r\nFROM Test2<\/pre>\n<p id=\"NbTvbnv\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-7766  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c3cfc4038059.png\" alt=\"\" width=\"543\" height=\"342\" \/><\/p>\n<p>We said that if there are no duplicate records in the two queries, UNION and UNION ALL will bring the same result.<\/p>\n<p><strong>So how are the performance values of UNION and UNION ALL?<\/strong><\/p>\n<p>The following two query will return the same result set. Because there is no duplicate record. When we examine the execution plans, the cost of the query is almost tripled as the Distinct Sort operation is done in the UNION process. Therefore, if you are sure that there are no duplicate records, you must use UNION ALL.<\/p>\n<pre class=\"lang:default decode:true\">SELECT [Name],[Surname],YEAR([Date])\r\nFROM Test\r\nWhere [Name]='Hakan'\r\nUNION\r\nSELECT [Name],[Surname],YEAR([Date])\r\nFROM Test2\r\nWhere [Name]='Nurullah'\r\nGO\r\nSELECT [Name],[Surname],YEAR([Date])\r\nFROM Test\r\nWhere [Name]='Hakan'\r\nUNION ALL\r\nSELECT [Name],[Surname],YEAR([Date])\r\nFROM Test2\r\nWhere [Name]='Nurullah'<\/pre>\n<p id=\"ywWLAeV\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-7768  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c3cfca132bd2.png\" alt=\"\" width=\"649\" height=\"231\" \/><\/p>\n\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\">\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_7753\" class=\"pvc_stats all  \" data-element-id=\"7753\" 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>&nbsp; With UNION and UNION ALL Opertors, we can merge multiple sql statement&#8217;s result in a single result set. When we merge two SQL statements with the UNION operator, duplicate records are listed once in the result set. When we merge two SQL statements with the UNION ALL operator, all results are listed. If there &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_7753\" class=\"pvc_stats all  \" data-element-id=\"7753\" 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":[1666,1667],"class_list":["post-7753","post","type-post","status-publish","format-standard","","category-mssql","category-tsql","tag-intersect-or-except-operator-must-have-an-equal-number-of-expressions-in-their-target-lists","tag-operand-type-clash-int-is-incompatible-with-date"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":464,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>UNION and UNION ALL Operators in SQL Server(TSQL) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"UNION and UNION ALL Operators 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\/14\/union-and-union-all-operators-in-sql-servertsql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"UNION and UNION ALL Operators in SQL Server(TSQL) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"UNION and UNION ALL Operators in SQL Server(TSQL)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-14T21:21:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c3cfb364ea0e.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\/14\/union-and-union-all-operators-in-sql-servertsql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"UNION and UNION ALL Operators in SQL Server(TSQL)\",\"datePublished\":\"2019-01-14T21:21:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/\"},\"wordCount\":453,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c3cfb364ea0e.png\",\"keywords\":[\"INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists\",\"Operand type clash: int is incompatible with date\"],\"articleSection\":[\"MSSQL\",\"TSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/\",\"name\":\"UNION and UNION ALL Operators in SQL Server(TSQL) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c3cfb364ea0e.png\",\"datePublished\":\"2019-01-14T21:21:23+00:00\",\"description\":\"UNION and UNION ALL Operators in SQL Server(TSQL)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c3cfb364ea0e.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c3cfb364ea0e.png\",\"width\":839,\"height\":458},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"UNION and UNION ALL Operators 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":"UNION and UNION ALL Operators in SQL Server(TSQL) - Database Tutorials","description":"UNION and UNION ALL Operators 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\/14\/union-and-union-all-operators-in-sql-servertsql\/","og_locale":"en_US","og_type":"article","og_title":"UNION and UNION ALL Operators in SQL Server(TSQL) - Database Tutorials","og_description":"UNION and UNION ALL Operators in SQL Server(TSQL)","og_url":"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/","og_site_name":"Database Tutorials","article_published_time":"2019-01-14T21:21:23+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c3cfb364ea0e.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\/14\/union-and-union-all-operators-in-sql-servertsql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"UNION and UNION ALL Operators in SQL Server(TSQL)","datePublished":"2019-01-14T21:21:23+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/"},"wordCount":453,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c3cfb364ea0e.png","keywords":["INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists","Operand type clash: int is incompatible with date"],"articleSection":["MSSQL","TSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/","url":"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/","name":"UNION and UNION ALL Operators in SQL Server(TSQL) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c3cfb364ea0e.png","datePublished":"2019-01-14T21:21:23+00:00","description":"UNION and UNION ALL Operators in SQL Server(TSQL)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c3cfb364ea0e.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c3cfb364ea0e.png","width":839,"height":458},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"UNION and UNION ALL Operators 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\/7753","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=7753"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/7753\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=7753"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=7753"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=7753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}