{"id":12308,"date":"2019-05-17T22:51:30","date_gmt":"2019-05-17T22:51:30","guid":{"rendered":"https:\/\/dbtut.com\/?p=12308"},"modified":"2019-05-18T01:00:34","modified_gmt":"2019-05-18T01:00:34","slug":"compound-operators-in-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/","title":{"rendered":"Compound Operators in SQL Server"},"content":{"rendered":"

With Compound Operators, we can make operations on variables more easily. For example, let’s assume that @a is a variable and we want to increase the value of @ a by 2. Under normal conditions, we can increase the value of @a by 2 with the process “@ a = @ a + 2”.<\/p>\n

With the “+ =” which is one of the compound operators, we can perform the same operation with @ a + = 2 in a simpler way.<\/p>\n

Below is a list of compound operators.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
Operator<\/strong><\/td>\nExplanation<\/strong><\/td>\n<\/tr>\n
+=<\/td>\nWe can use @a+=2 instead of @a=@a+2<\/td>\n<\/tr>\n
-=<\/td>\nWe can use @a-=2 instead of @a=@a-2<\/td>\n<\/tr>\n
*=<\/td>\nWe can use @a*=2 instead of @a=@a*2<\/p>\n

 <\/p>\n

For Example;<\/b><\/p>\n

Declare @a int<\/p>\n

SET @a=3;<\/p>\n

SET @a*=3<\/p>\n

Select @a<\/p>\n

 <\/td>\n<\/tr>\n

\/=<\/td>\nWe can use @a\/=2 instead of @a=@a\/2<\/td>\n<\/tr>\n
%=<\/td>\nWe can use @a%=2 instead of @a=@a%2.<\/p>\n

 <\/p>\n

The % sign returns the remainder as a result when you divide a number by the other number.<\/p>\n

 <\/p>\n

For example, suppose that the value of @a is initially 9. As a result of “@a%=4”, the value of @a will be 1. Because if you divide 9 by 4, the remainder will be 1.<\/td>\n<\/tr>\n

&=<\/td>\nPerforms a “bitwise AND” operation. For example;<\/p>\n

 <\/p>\n

Declare @myvariable int<\/p>\n

Set @myvariable = 170<\/p>\n

Set @myvariable &=75<\/p>\n

Select @myvariable as Result<\/p>\n

 <\/p>\n

The binary value of the value 170 in the query is “0000 0000 1010 1010” and the binary value of 75 is “0000 0000 0100 1011”.<\/p>\n

 <\/p>\n

When you perform “AND” operation on these two binary values, the result will be 10. The AND operation is the result of the multiplication of both binary values. That is, if the two corresponding values \u200b\u200bare 1, the result will be 1. If any is zero, the result will be 0.<\/td>\n<\/tr>\n

^=<\/td>\nPerforms a “bitwise Exclusive OR”. For example;<\/p>\n

 <\/p>\n

Declare @myvariable int<\/p>\n

Set @myvariable = 170<\/p>\n

Set @myvariable ^=75<\/p>\n

Select @myvariable as Result<\/p>\n

 <\/p>\n

The binary value of 170 in the query is “0000 0000 1010 1010”. The binary value of 75 is “0000 0000 0100 1011”.  When you perform “exlusive OR” operation on these two binary values, the result will be “0000 0000 1110 0001”. That is, if one of the two corresponding values \u200b\u200bare 1, the result will be 1. If both of them are 1, the result will be 0. When you run the query, the result will return 225. Because the decimal value of “0000 0000 1110 0001” is 225.<\/td>\n<\/tr>\n

|=<\/td>\nPerforms a “bitwise OR”. For example;<\/p>\n

 <\/p>\n

Declare @myvariable int<\/p>\n

Set @myvariable = 170<\/p>\n

Set @myvariable |=75<\/p>\n

Select @myvariable as Result<\/p>\n

 <\/p>\n

The binary value of 170 in the query is “0000 0000 1010 1010”. The binary value of 75 is “0000 0000 0100 1011”.  When you perform “OR” operation on these two binary values, the result will be “0000 0000 1110 1011”.  That is, if one of the two corresponding values \u200b\u200bare 1, the result will be 1.  When you run the query, the result will return 235. Because the decimal value of “0000 0000 1110 1011” is 235.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

With Compound Operators, we can make operations on variables more easily. For example, let’s assume that @a is a variable and we want to increase the value of @ a by 2. Under normal conditions, we can increase the value of @a by 2 with the process “@ a = @ a + 2”. With …<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":1,"featured_media":12312,"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":[],"class_list":["post-12308","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","category-tsql"],"aioseo_notices":[],"yoast_head":"\nCompound Operators in SQL Server - Database Tutorials<\/title>\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\/05\/17\/compound-operators-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Compound Operators in SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"With Compound Operators, we can make operations on variables more easily. For example, let’s assume that @a is a variable and we want to increase the value of @ a by 2. Under normal conditions, we can increase the value of @a by 2 with the process “@ a = @ a + 2”. With …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-17T22:51:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-05-18T01:00:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-55.png\" \/>\n\t<meta property=\"og:image:width\" content=\"631\" \/>\n\t<meta property=\"og:image:height\" content=\"387\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/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=\"2 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\/05\/17\/compound-operators-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Compound Operators in SQL Server\",\"datePublished\":\"2019-05-17T22:51:30+00:00\",\"dateModified\":\"2019-05-18T01:00:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/\"},\"wordCount\":438,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-55.png\",\"articleSection\":[\"MSSQL\",\"TSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/\",\"name\":\"Compound Operators in SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-55.png\",\"datePublished\":\"2019-05-17T22:51:30+00:00\",\"dateModified\":\"2019-05-18T01:00:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-55.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-55.png\",\"width\":631,\"height\":387},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Compound Operators in SQL Server\"}]},{\"@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":"Compound Operators in SQL Server - Database Tutorials","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\/05\/17\/compound-operators-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Compound Operators in SQL Server - Database Tutorials","og_description":"With Compound Operators, we can make operations on variables more easily. For example, let’s assume that @a is a variable and we want to increase the value of @ a by 2. Under normal conditions, we can increase the value of @a by 2 with the process “@ a = @ a + 2”. With …","og_url":"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2019-05-17T22:51:30+00:00","article_modified_time":"2019-05-18T01:00:34+00:00","og_image":[{"width":631,"height":387,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-55.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Compound Operators in SQL Server","datePublished":"2019-05-17T22:51:30+00:00","dateModified":"2019-05-18T01:00:34+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/"},"wordCount":438,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-55.png","articleSection":["MSSQL","TSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/","name":"Compound Operators in SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-55.png","datePublished":"2019-05-17T22:51:30+00:00","dateModified":"2019-05-18T01:00:34+00:00","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-55.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-55.png","width":631,"height":387},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/17\/compound-operators-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Compound Operators in SQL Server"}]},{"@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\/12308","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=12308"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12308\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/12312"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=12308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=12308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=12308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}