title: Update data during insert in a Trigger and then insert
body: <p>I have situation where, I have 10 columns in a table. I am inserting 5 columns from a program and for 5 columns, I want to create a trigger. Is it possible? And if yes, How do I do that?</p>
  
  <p>col1 col2 col3 col4 col5 col6 col7 col8 col9 col10</p>
  
  <pre><code>CREATE TRIGGER Fill_Trigger
     ON  DB 
     AFTER INSERT
  AS 
  BEGIN
      -- SET NOCOUNT ON added to prevent extra result sets from
      -- interfering with SELECT statements.
      SET NOCOUNT ON;
  
      -- Insert statements for trigger here
      DECLARE @COL6 INT
      DECLARE @COL7 INT -- and so on.
  
  
     SET @COL6 = (SELECT COL1 FROM inserted) * (SELECT COL2 FROM inserted)
     SET @COL7 = (SELECT COL3 FROM inserted) * (SELECT COL4 FROM inserted)
  
     --Is it possible to do the following?
    UPDATE inserted SET COL6 = @COL6
    UPDATE inserted SET COL7 = @COL7
  END
  GO
  </code></pre>