title: Can I update column value into a trigger when insert event happens?
body: <p>I am using SQL Server 2008. Can I update a column value in the same table on which an insert trigger happens?</p>
  
  <p>I.e., can I use this code?</p>
  
  <pre><code>CREATE TRIGGER tr_Table1_Insert_Table1name
  ON Table1name
  FOR INSERT AS
  
  BEGIN
  
   UPDATE @NEW
      SET COLUMN = 3;
  
  END
  GO
  </code></pre>
  
  <p>If "No", how can make this happen?</p>