title: select query to list all rows in chronological order?
body: <p>how to write a select query to list all rows in chronological order,with undated records appearing last?</p>
  
  <pre><code>    Create Table Demo(Col1 VARCHAR(10), Col2 SMALLDATETIME NULL)
  
      Insert into Demo Values('TG', '2009-03-08')
      Insert into Demo Values('YG', NULL)
  </code></pre>