SQLzoo.net

Formatting numbers to two decimal places.

SQL Server
This rounds up or down


Specific to SQL Server
Also consider CAST(population/1000000 AS decimal(8,2))

Related links:

  • FUNCTIONS