{"id":259343,"date":"2024-04-10T19:34:26","date_gmt":"2024-04-10T19:34:26","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=259343"},"modified":"2024-04-10T19:34:26","modified_gmt":"2024-04-10T19:34:26","slug":"how-to-add-two-columns-value-in-sql-server","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/","title":{"rendered":"How to add two columns value in SQL Server?"},"content":{"rendered":"<p>Adding two columns value in SQL Server is a common requirement when working with relational databases. Fortunately, SQL Server provides simple and straightforward ways to achieve this. In this article, we will explore the different approaches to add two columns value in SQL Server.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#Method_1_Using_the_plus_operator\" title=\"Method 1: Using the plus (+) operator\">Method 1: Using the plus (+) operator<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#Method_2_Using_the_SUM_function\" title=\"Method 2: Using the SUM() function\">Method 2: Using the SUM() function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#Frequently_Asked_Questions\" title=\"Frequently Asked Questions\">Frequently Asked Questions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#Q1_Can_I_add_columns_of_different_data_types_together\" title=\"Q1: Can I add columns of different data types together?\">Q1: Can I add columns of different data types together?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#Q2_What_if_one_of_the_columns_has_NULL_values\" title=\"Q2: What if one of the columns has NULL values?\">Q2: What if one of the columns has NULL values?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#Q3_Can_I_add_more_than_two_columns_together\" title=\"Q3: Can I add more than two columns together?\">Q3: Can I add more than two columns together?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#Q4_How_can_I_round_the_result_of_the_addition_to_a_specific_decimal_place\" title=\"Q4: How can I round the result of the addition to a specific decimal place?\">Q4: How can I round the result of the addition to a specific decimal place?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#Q5_Is_it_possible_to_perform_other_arithmetic_operations_such_as_subtraction_or_multiplication\" title=\"Q5: Is it possible to perform other arithmetic operations, such as subtraction or multiplication?\">Q5: Is it possible to perform other arithmetic operations, such as subtraction or multiplication?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#Q6_Can_I_use_column_aliases_in_the_arithmetic_operation\" title=\"Q6: Can I use column aliases in the arithmetic operation?\">Q6: Can I use column aliases in the arithmetic operation?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#Q7_Will_adding_two_columns_modify_the_original_table\" title=\"Q7: Will adding two columns modify the original table?\">Q7: Will adding two columns modify the original table?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#Q8_How_can_I_add_columns_from_different_tables\" title=\"Q8: How can I add columns from different tables?\">Q8: How can I add columns from different tables?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#Q9_Can_I_add_a_constant_value_to_a_column\" title=\"Q9: Can I add a constant value to a column?\">Q9: Can I add a constant value to a column?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#Q10_Are_there_any_performance_considerations_when_adding_columns\" title=\"Q10: Are there any performance considerations when adding columns?\">Q10: Are there any performance considerations when adding columns?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#Q11_Is_there_any_limit_to_the_number_of_columns_that_can_be_added_together\" title=\"Q11: Is there any limit to the number of columns that can be added together?\">Q11: Is there any limit to the number of columns that can be added together?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#Q12_Can_I_add_columns_conditionally_based_on_certain_criteria\" title=\"Q12: Can I add columns conditionally based on certain criteria?\">Q12: Can I add columns conditionally based on certain criteria?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Method_1_Using_the_plus_operator\"><\/span>Method 1: Using the plus (+) operator<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The plus (+) operator in SQL Server allows us to concatenate strings as well as perform arithmetic operations on numeric values. To add two columns together, simply use the plus operator between the column names.<\/p>\n<p>Let&#8217;s assume we have a table called &#8220;myTable&#8221; with two columns: &#8220;column1&#8221; and &#8220;column2&#8221;. To add the values in these columns and retrieve the result as a new column, the following query can be used:<\/p>\n<p>&#8220;`sql<br \/>\nSELECT column1, column2, (column1 + column2) AS sum FROM myTable;<br \/>\n&#8220;`<\/p>\n<p>This query will return the individual values of &#8220;column1&#8221; and &#8220;column2&#8221;, along with the sum of both columns in a new column named &#8220;sum&#8221;.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_2_Using_the_SUM_function\"><\/span>Method 2: Using the SUM() function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Another approach to add two columns in SQL Server is by utilizing the SUM() function. This function is primarily used to calculate the total sum of a specific column or expression. However, it can also be used to add values from multiple columns.<\/p>\n<p>&#8220;`sql<br \/>\nSELECT column1, column2, SUM(column1 + column2) AS sum FROM myTable;<br \/>\n&#8220;`<\/p>\n<p>By applying the SUM() function to the sum of &#8220;column1&#8221; and &#8220;column2&#8221;, we can obtain the result in a single query.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions\"><\/span>Frequently Asked Questions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Q1_Can_I_add_columns_of_different_data_types_together\"><\/span>Q1: Can I add columns of different data types together?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can add columns of different data types together as long as their data types are compatible. SQL Server automatically converts the values to a common data type before adding them.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q2_What_if_one_of_the_columns_has_NULL_values\"><\/span>Q2: What if one of the columns has NULL values?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nWhen adding columns with NULL values, the result will also be NULL. If you want to exclude NULL values from the calculation, you can use the ISNULL() function to replace them with a default value or zero.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q3_Can_I_add_more_than_two_columns_together\"><\/span>Q3: Can I add more than two columns together?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can add more than two columns together using the same methods described above. Simply include additional columns within the arithmetic operation or the SUM() function.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q4_How_can_I_round_the_result_of_the_addition_to_a_specific_decimal_place\"><\/span>Q4: How can I round the result of the addition to a specific decimal place?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo round the result of the addition, you can use the ROUND() function. For example, if you want to round the sum to two decimal places, you can modify the query like this:<\/p>\n<p>&#8220;`sql<br \/>\nSELECT column1, column2, ROUND(column1 + column2, 2) AS rounded_sum FROM myTable;<br \/>\n&#8220;`<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q5_Is_it_possible_to_perform_other_arithmetic_operations_such_as_subtraction_or_multiplication\"><\/span>Q5: Is it possible to perform other arithmetic operations, such as subtraction or multiplication?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, SQL Server provides operators for subtraction (-), multiplication (*), and division (\/) as well. You can use these operators in a similar manner to perform such operations on columns.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q6_Can_I_use_column_aliases_in_the_arithmetic_operation\"><\/span>Q6: Can I use column aliases in the arithmetic operation?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, you cannot directly use column aliases in the arithmetic operation without repeating the entire expression. However, you can use subqueries or derived tables to simplify the code and avoid repetition.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q7_Will_adding_two_columns_modify_the_original_table\"><\/span>Q7: Will adding two columns modify the original table?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, adding two columns together using these methods does not modify the original table. The addition occurs during the retrieval of data, and the original values remain unchanged.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q8_How_can_I_add_columns_from_different_tables\"><\/span>Q8: How can I add columns from different tables?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo add columns from different tables, you need a common column or a relationship between the tables. You can then join the tables using appropriate join statements and perform the addition on the desired columns.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q9_Can_I_add_a_constant_value_to_a_column\"><\/span>Q9: Can I add a constant value to a column?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can add a constant value to a column in the same way as adding two columns together. Instead of referencing another column, use the constant value directly in the arithmetic operation or the SUM() function.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q10_Are_there_any_performance_considerations_when_adding_columns\"><\/span>Q10: Are there any performance considerations when adding columns?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nWhile adding columns is a simple operation, it can have performance implications if performed on a large dataset or frequently in a query. To optimize performance, ensure proper indexing on the involved columns and consider the overall query design.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q11_Is_there_any_limit_to_the_number_of_columns_that_can_be_added_together\"><\/span>Q11: Is there any limit to the number of columns that can be added together?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, there is no inherent limit on the number of columns that can be added together. However, it&#8217;s essential to avoid unnecessarily complex and lengthy queries for clarity and maintainability.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q12_Can_I_add_columns_conditionally_based_on_certain_criteria\"><\/span>Q12: Can I add columns conditionally based on certain criteria?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can add columns conditionally by using the CASE statement. The CASE statement allows you to specify different conditions and perform different addition operations based on those conditions.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Adding two columns value in SQL Server is a common requirement when working with relational databases. Fortunately, SQL Server provides simple and straightforward ways to achieve this. In this article, we will explore the different approaches to add two columns value in SQL Server. Method 1: Using the plus (+) operator The plus (+) operator &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to add two columns value in SQL Server?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#more-259343\">Read more<span class=\"screen-reader-text\">How to add two columns value in SQL Server?<\/span><\/a><\/p>\n","protected":false},"author":65,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-259343","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learn","no-featured-image-padding"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to add two columns value in SQL Server?<\/title>\n<meta name=\"description\" content=\"Adding two columns value in SQL Server is a common requirement when working with relational databases. Fortunately, SQL Server provides simple and\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to add two columns value in SQL Server?\" \/>\n<meta property=\"og:description\" content=\"Adding two columns value in SQL Server is a common requirement when working with relational databases. Fortunately, SQL Server provides simple and\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/synchronyfinancial\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-10T19:34:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Timothy Mathis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@synchrony\" \/>\n<meta name=\"twitter:site\" content=\"@synchrony\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Timothy Mathis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/\"},\"author\":{\"name\":\"Timothy Mathis\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/ffa5be155490b2344e28f672fcc1e318\"},\"headline\":\"How to add two columns value in SQL Server?\",\"datePublished\":\"2024-04-10T19:34:26+00:00\",\"dateModified\":\"2024-04-10T19:34:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/\"},\"wordCount\":772,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"articleSection\":[\"Learn\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/\",\"name\":\"How to add two columns value in SQL Server?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-04-10T19:34:26+00:00\",\"dateModified\":\"2024-04-10T19:34:26+00:00\",\"description\":\"Adding two columns value in SQL Server is a common requirement when working with relational databases. Fortunately, SQL Server provides simple and\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to add two columns value in SQL Server?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"description\":\"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co\",\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/namso-gen.co\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"contentUrl\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"width\":500,\"height\":164,\"caption\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\"},\"image\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/synchronyfinancial\",\"https:\/\/twitter.com\/synchrony\",\"https:\/\/www.youtube.com\/synchronyfinancial\",\"https:\/\/www.instagram.com\/synchrony\",\"https:\/\/www.linkedin.com\/company\/synchrony-financial\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/ffa5be155490b2344e28f672fcc1e318\",\"name\":\"Timothy Mathis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"caption\":\"Timothy Mathis\"},\"description\":\"Guest author Timothy Mathis has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to add two columns value in SQL Server?","description":"Adding two columns value in SQL Server is a common requirement when working with relational databases. Fortunately, SQL Server provides simple and","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:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"How to add two columns value in SQL Server?","og_description":"Adding two columns value in SQL Server is a common requirement when working with relational databases. Fortunately, SQL Server provides simple and","og_url":"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2024-04-10T19:34:26+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png","type":"image\/png"}],"author":"Timothy Mathis","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Timothy Mathis","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/"},"author":{"name":"Timothy Mathis","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/ffa5be155490b2344e28f672fcc1e318"},"headline":"How to add two columns value in SQL Server?","datePublished":"2024-04-10T19:34:26+00:00","dateModified":"2024-04-10T19:34:26+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/"},"wordCount":772,"commentCount":0,"publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"articleSection":["Learn"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/","url":"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/","name":"How to add two columns value in SQL Server?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-04-10T19:34:26+00:00","dateModified":"2024-04-10T19:34:26+00:00","description":"Adding two columns value in SQL Server is a common requirement when working with relational databases. Fortunately, SQL Server provides simple and","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-add-two-columns-value-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to add two columns value in SQL Server?"}]},{"@type":"WebSite","@id":"https:\/\/namso-gen.co\/blog\/#website","url":"https:\/\/namso-gen.co\/blog\/","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","description":"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co","publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/namso-gen.co\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/namso-gen.co\/blog\/#organization","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","url":"https:\/\/namso-gen.co\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","contentUrl":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","width":500,"height":164,"caption":"Namso Gen Blog - Free Credit Card Generator [100% Valid]"},"image":{"@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/synchronyfinancial","https:\/\/twitter.com\/synchrony","https:\/\/www.youtube.com\/synchronyfinancial","https:\/\/www.instagram.com\/synchrony","https:\/\/www.linkedin.com\/company\/synchrony-financial"]},{"@type":"Person","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/ffa5be155490b2344e28f672fcc1e318","name":"Timothy Mathis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Timothy Mathis"},"description":"Guest author Timothy Mathis has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here."}]}},"_links":{"self":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/259343","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/users\/65"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=259343"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/259343\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media\/107420"}],"wp:attachment":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media?parent=259343"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=259343"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=259343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}