title: SQL get date month from query
body: <p>I have a datecolumn called invoicedate,</p>
  
  <p>my query is:</p>
  
  <pre><code>select
      MONTH(dbo.tblInvoices.InvoiceDate) as datemonth,
      Year(dbo.tblInvoices.InvoiceDate)as dateYear
  from
      dbo.tblInvoices
  </code></pre>
  
  <p>this return 9|2009 ect...</p>
  
  <p>How do I get those to return as one string, as in one column not two?  output example: 9/2009</p>
  
  <p>SQL server 2005</p>