Write a number with two decimal places SQL server

Question

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

Answer 1

Try the below code:

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