title: SQL Server insert multiple records with same datetime
body: <p>I have a table that has a datetime column that I wish to insert multiple records into at the same time.  It is necessary that the datetime is exactly the same so I can late compare which records were inserted together.  Is it sufficient to do something like this:</p>
  
  <pre><code>INSERT INTO Table(Date, ID, etc...)
  VALUES (GETDATE(), ...)
  </code></pre>
  
  <p>Or should I declare a variable earlier in the stored procedure to hold the current time and just use that as the value to insert.</p>
  
  <p>I have tested and it seems like the first method works fine, I just want to be 100% certain.  </p>
  
  <hr>
  
  <p>Edit: I think the question is better stated as "How often does GETDATE() get executed in a stored procedure?"</p>