title: How to create dates from date components in SQL (T-SQL)?
body: <p>How can I construct native date data type values in SQL (T-SQL)?</p>
  
  <p>I've added some examples, but please provide your own. My examples assume that the month and year are being stored (or are readily available) as integer values, but maybe <em>your</em> example will assume that the day and the month (or whatever) are stored as text. I can't see the future; surprise me.</p>