title: Next/previous record based on current
body: <p>I have a table which is not sorted by any of column. Is there any way to select next/previous record if I know only Id of current? (I'm using mssql)</p>
  
  <pre><code>Id     Label     Date
  ---------------------
  1      label1    2011-01-10
  7      label2    2011-01-15 -- how to get previous?
  5      label3    2011-01-12 -- I know id of this record
  10     label10   2011-01-25 -- how to get next?
  12     label8    2011-01-13
  2      label5    2011-01-29
  </code></pre>
  
  <p>Thanks in advance!</p>