title: Insert Trigger for Non null columns in SQL Server
body: <p>I have a followed table:</p>
  
  <p><strong>JobSkill</strong></p>
  
  <pre><code>CreatedByID not null, 
  CreatedDate not null, 
  ModifiedByID not null, 
  ModifiedDate not null
  </code></pre>
  
  <p>I need to insert a record by procedure and trigger.
  <code>CreatedByID</code> and <code>ModifiedByID</code> are inserted through procedure.</p>
  
  <p>I need to create trigger for inserting <code>CreatedDate</code> and <code>ModifiedDate</code>.</p>
  
  <p>When I am executing insert method in MSSQL, I am getting this error.</p>
  
  <pre><code>Msg 515, Level 16, State 2, Line 1
  Cannot insert the value NULL into column 'CreatedDate', table 'One91.dbo.JobSkill'; column does not allow nulls. INSERT fails.
  The statement has been terminated.
  </code></pre>
  
  <p>Can anyone help me in this issue pls.</p>