title: Can a temporal table historize insert?
body: <p>I have created the following temportal table</p>
  
  <pre><code>/*
  ALTER TABLE [dbo].________Test SET ( SYSTEM_VERSIONING = OFF)
  GO
  DROP TABLE dbo.________Test
  GO
  DROP TABLE dbo.________TestHistory
  GO
  */
  
  CREATE TABLE dbo.________Test
  (
      DeptID INT NOT NULL PRIMARY KEY CLUSTERED
    , DeptName VARCHAR(50) NOT NULL
    , ManagerID INT NULL
    , ParentDeptID INT NULL
    , SysStartTime DATETIME2 GENERATED ALWAYS AS ROW START NOT NULL
    , SysEndTime DATETIME2 GENERATED ALWAYS AS ROW END NOT NULL
    , PERIOD FOR SYSTEM_TIME (SysStartTime, SysEndTime)
  -- ) WITH (SYSTEM_VERSIONING = ON); 
  ) WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = dbo.________TestHistory));
  </code></pre>
  
  <p>Now I can insert, update and delete values. <br />
  But the values do only get historized on an update or a delete. <br />
  <strong>Is there a way to historize the insert-statements, too ?</strong> </p>
  
  <p>I want to avoid having to write a trigger for that, if at all possible... <br />
  Having the data in two tables is extremely disadvantageous, because then i need to create a union first, and miss out on any field created afterwards, or I have potentially garbage columns if I use SELECT * and create a union-view, if the column-order gets altered, plus new columns would be missing, too. </p>
  
  <p>Hmmm, those temporal tables seem to be really stupid(ly made)... <br />
  Apparently, they historize every potential change, even if there's no change in the data. <br />
  So I can do this: </p>
  
  <pre><code>CREATE TRIGGER TR_________Test_AfterInsert ON dbo.________Test
      AFTER INSERT
  AS
  BEGIN 
      UPDATE dbo.________Test 
          SET DeptID = DeptID 
      WHERE DeptID IN 
      (
          SELECT DeptID
          FROM inserted
      )
  END
  </code></pre>
  
  <p>And the entries will swiftly be historized after insert. <br />
  On the other hand, this is nice, since then I don't have to manually synchronize the table-schema with the history-table-schema. </p>