sql - 写一个带有两个小数位的SQL服务器的数字(Write a number with two decimal places SQL server)

Question

如何为sql server编写带小数位数的两位数？

  ask by translate from so

Answer 1

试试这个

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