title: How can I edit values of an INSERT in a trigger on SQL Server?
body: <p>I have the table <code>Tb</code></p>
  
  <pre><code>ID | Name   | Desc
  -------------------------
   1 | Sample | sample desc
  </code></pre>
  
  <p>I want to create a trigger on INSERT that will change the value of the inserting <code>Desc</code>, for example:</p>
  
  <pre><code>INSERT INTO Tb(Name, Desc) VALUES ('x', 'y')
  </code></pre>
  
  <p>Will result in</p>
  
  <pre><code>ID | Name   | Desc
  -------------------------
   1 | Sample | sample desc
   2 | x      | Y edited
  </code></pre>
  
  <p>In the above example I got the value of the inserting <code>Desc</code> changed it to uppercase and added <code>edited</code> on the end.</p>
  
  <p>That's what I need, get the <code>Desc</code> that is being inserted and modify it.</p>
  
  <p>How can I do that?</p>
  
  <p>Is it better to handle it after the insert with an update? Or make a trigger with INSTEAD OF INSERT and modify it everytime the table structure changes?</p>