title: Table Partitioning Using created time for each row
body: <p>I am using SQL Server. And I am looking for a solution to partition table based on the <code>created_time</code> column for each row.</p>
  
  <p>For example: when <code>created_time = 2019-12-01</code> (<code>yyyy-MM-dd</code>) my partition key should be <code>yyyy * 100 + MM</code> i.e. 201912.</p>
  
  <p>Is there a way to achieve this right at the moment a row is inserted and without adding an extra column in the table (without storing the partition key in the table itself)?</p>
  
  <p>Thanks!</p>