title: Rounding to two digits in SQL Server 2008
body: <p>it s enough to round a column value in plsql by using <code>round(value,2)</code>. For example 1.2222 can be converted to 1.22 by that function in plsql. </p>
  
  <p>How can I do that in SQL Server? When I use <code>round(1.2222,2)</code>, it converts 1.2200. I want 1.22. Thanks for help</p>