SQL Server/T-SQL/Data Type/Number Format

Format decimal

1> SELECT CONVERT(Decimal(9,2), "123.4")
2>
3> GO
-----------
     123.40
(1 rows affected)
1>

Format decimal: Decimal(9,2)

1> SELECT CAST("123.4" AS Decimal(9,2))
2> GO
-----------
     123.40
(1 rows affected)
1>