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

Popular posts from this blog

c++ - Linux and clipboard -

What is expire header and how to achive them in ASP.NET and PHP? -

sql server - How can I determine which of my SQL 2005 statistics are unused? -