title: GetDate() causes error when used with EXEC
body: <p>MS SQL Server 2008.</p>
  
  <p>Why does this parse ok:</p>
  
  <pre><code>CREATE TABLE #Held
  (
      Value decimal(18,4)
  )
  INSERT #Held EXEC dbo.sp_Held '2013-06-27', NULL
  </code></pre>
  
  <p>But this gives a syntax error(<em>Incorrect syntax near 'day'.</em>):</p>
  
  <pre><code>CREATE TABLE #Held
  (
      Value decimal(18,4)
  )
  INSERT #Held EXEC dbo.sp_Held DATEADD(day, -1, getdate()), NULL
  </code></pre>
  
  <p>?</p>