title: Insert into SQL Server timestamp
body: <p>I have <code>table1</code> and <code>table2</code> and I am inserting data into <code>table3</code> based on rows from tables 1 + 2. I need get evidence in to table 3 when was data insert.</p>
  
  <p><strong>Table1</strong>:</p>
  
  <pre><code>Column1
  a
  b
  d
  e
  g
  h
  i
  </code></pre>
  
  <p><strong>Table2</strong>:</p>
  
  <pre><code>Column1
  a
  b
  c
  d
  e
  f
  </code></pre>
  
  <p>Code:</p>
  
  <pre><code>INSERT INTO [dbo].[table3](column1)
      SELECT column1
      FROM [dbo].[table2]
      WHERE NOT EXISTS (SELECT
                        FROM [dbo].[table1]
                        WHERE column1 = column1);
  </code></pre>
  
  <p>Result:</p>
  
  <p><strong>Table3</strong>:</p>
  
  <pre><code>Column1  Column2
  c
  f
  </code></pre>
  
  <p>I need get in to exist table and exist column (<code>varchar(50)</code> or <code>timestamp</code>) any format of time which will show me time when was insert values in to table using my current script.</p>
  
  <p>Example:</p>
  
  <p><strong>Table3</strong>:</p>
  
  <pre><code>Column1 Column2
  c       4/4/2017 
  f       4/4/2017
  </code></pre>
  
  <p>Few days later should table look like this :</p>
  
  <p><strong>Table3</strong>:</p>
  
  <pre><code>Column1 Column2
  c       4/4/2017 
  f       4/4/2017
  x       5/4/2017  
  y       6/4/2017
  z       10/4/2019
  </code></pre>
  
  <p>Thanks for upgrade my script  for :</p>
  
  <p>Something like :</p>
  
  <pre><code>INSERT INTO table3 (Column2) 
  VALUES (CURRENT_TIMESTAMP);
  </code></pre>