title: How to update all fields dynamically in Instead of UPDATE trigger SQL Server
body: <p>I am implementing Instead of UPDATE trigger in SQL-server, want to update all the fields without being in need to cache the values from the INSERTED table and then set it to the fields in the UPDATE Query .. How Can I do This ?!</p>
  
  <pre><code>CREATE TRIGGER trg_Instead_updTable1 ON dbo.Table1
  INSTEAD OF UPDATE
  AS
  BEGIN
      IF (UPDATE(ID))
             RAISERROR ('It is not allowed to update a Table1.ID', 16, 1)
      ELSE
             BEGIN
                  UPDATE dbo.Table1
                  SET * = (SELECT * FROM INSERTED JOIN DELETED ON INSERTED.ID = DELETED.ID)
             END
  END
  </code></pre>