Format decimal: Decimal(9,2) : Number Format « Data Type « SQL Server / T-SQL






Format decimal: Decimal(9,2)


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

-----------
     123.40

(1 rows affected)
1>
           
       








Related examples in the same category

1.Format decimal