title: SQL Server Trigger - Variable Table Name
body: <p>Is there anyway to update variable tables using SQL triggers?</p>
  
  <p>I have one table called <strong>Readings</strong> that is updated with multiple different point numbers, I would like to have a trigger on this table that will read this point number and then update the specific table.</p>
  
  <p>I have the following trigger that works, but the table name <strong>Z01</strong> I would like to be a variable depending on the inserted data. Is this possible?</p>
  
  <pre><code>CREATE TRIGGER [dbo].[TRG_InsertTest] 
  ON [dbo].[readings]
  AFTER INSERT AS
  BEGIN
  INSERT INTO Z01 
  SELECT * FROM INSERTED
  END
  </code></pre>