title: How to SUM up 2 Columns into 1 Column SQL Server
body: <p>I am really new to SQL Server so I wanted to know a few things. I made a database and was trying to make it so the 3rd column sums up the 1st and 2nd. I'm not sure if I have to query into CREATE TO or INSERT TO. Since I am new, I don't really know what to search for online. </p>
  
  <p>For Example: </p>
  
  <p>CREATE TO QUERY displays: </p>
  
  <pre><code>CREATE TABLE [dbo].[INVOICE](
      [ID_Order] [nchar](10) NOT NULL,
      [Product_Total] [decimal](18, 2) NOT NULL,
      [Shipping_Total] [decimal](18, 2) NOT NULL,
      [Total_Price] [decimal](18, 2) NOT NULL,
      [MCT_Code] [nchar](10) NULL,
      [ID_Shipping] [nchar](10) NULL,
  </code></pre>
  
  <p>While INSERT TO QUERY displays:</p>
  
  <pre><code>INSERT INTO [dbo].[INVOICE]
             ([ID_Order]
             ,[Product_Total]
             ,[Shipping_Total]
             ,[Total_Price]
             ,[MCT_Code]
             ,[ID_Shipping])
       VALUES
         (&lt;ID_Order, nchar(10),&gt;
         ,&lt;Product_Total, decimal(18,2),&gt;
         ,&lt;Shipping_Total, decimal(18,2),&gt;
         ,&lt;Total_Price, decimal(18,2),&gt;
         ,&lt;MCT_Code, nchar(10),&gt;
         ,&lt;ID_Shipping, nchar(10),&gt;)
  GO
  </code></pre>
  
  <p>Basically I want <code>[Product_Total] + [Shipping_Total]</code> to autopopulate the sum into <code>[Total_Price]</code>. If it's done through the query, do I press execute? I have tried a few things but there always seems to be an error </p>