title: SQL Server - after insert trigger - update another column in the same table
body: <p>I've got this database trigger:</p>
  
  <pre><code>CREATE TRIGGER setDescToUpper
  ON part_numbers
   AFTER INSERT,UPDATE
  AS
  DECLARE @PnumPkid int, @PDesc nvarchar(128)
  
  SET @PnumPkid = (SELECT pnum_pkid FROM inserted)
  SET @PDesc = (SELECT UPPER(part_description) FROM inserted)
  
  UPDATE part_numbers set part_description_upper = @PDesc WHERE pnum_pkid=@PnumPkid
  
  GO
  </code></pre>
  
  <p><strong>Is this a bad idea?</strong> That is to update a column on the same table. I want it to fire for both insert and update. </p>
  
  <p>It works, I'm just afraid of a cyclical situation. The update, inside the trigger, fires the trigger, and again and again. <strong>Will that happen?</strong></p>
  
  <p>Please, don't nitpick at the upper case thing. Crazy situation.</p>