Set Number with decimal format in SQL SERVER

When we want to set number with decimal format

Example 205402.5
And the result = 205402.50

We can convert amount value to decimal or numeric

Example in SQL Server =
select cast(205402.5 as decimal(10,2))

 

Technorati Tags: decimal format in SQL SERVER,set amount with decimal format