How to show decimal zeroes for a number in SQL Server -
I am pulling the following numbers from MS SQL Server:
345 345.6 345.67
How do I drag them so that they look like the following:
345.00 345.60 345.67
What datatypes should they be stored and what is the magic task to drag them? / P>
Thank you.
You can use the cast function. Since you are extracting the value of a table, you will use a selection and can be used like a few things -
select CAST (value AS DECIMAL (5,2) )) From the table
I hope you want this.
Cheers
Comments
Post a Comment