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

Format decimal

   <source lang="sql">

1> SELECT CONVERT(Decimal(9,2), "123.4") 2> 3> GO

---

    123.40

(1 rows affected) 1>

      </source>
   
  

Format decimal: Decimal(9,2)

   <source lang="sql">

1> SELECT CAST("123.4" AS Decimal(9,2)) 2> GO

---

    123.40

(1 rows affected) 1>

      </source>