Write a number with two decimal places SQL server

sql sql-server decimal number-formatting
student2009 picture student2009 · Jan 14, 2009 · Viewed 836.4k times · Source

How do you write a number with two decimal places for sql server?

Answer

Manoj picture Manoj · Feb 12, 2009

try this

SELECT CONVERT(DECIMAL(10,2),YOURCOLUMN)

Related questions

How to store decimal values in SQL Server?

I'm trying to figure out decimal data type of a column in the SQL Server. I need to be able to store values like 15.5, 26.9, 24.7, 9.8, etc I assigned decimal(18, 0) to the column data type but this not allowing me to store …

Read More
When to use Money data or Decimal Data type in sql server to store costing values?

What is preferable data type to store the costing value ? Money or Decimal whats the programmatic diff bet them? asp.net Data Annotation for asp.net Model for Money data type ?

Read More
SQL server integer vs decimal SUM

This is probably a newb question but...I was working on a db in SQSH and it had integer type values that were large (a population attribute). When I wanted to sum these up I got an arithmetic overflow exception. …

Read More