title: TSQL -- Inserting Dates Into Dynamic SQL
body: <p>Consider the following TSQL:</p>
  
  <pre><code>SET @WhereClause1 = 'where a.Date &gt; ' + @InvoiceDate
  </code></pre>
  
  <p>I get a date/string conversion error.  <code>@InvoiceDate</code> is a datetime variable.  What is the right syntax?</p>