How to display two digits after decimal point in SQL Server

by 
select cast(your_float_column as decimal(10,2))
from your_table

decimal(10,2) means you can have a decimal number with a maximal total precision of 10 digits. 2 of them after the decimal point and 8 before.
The biggest possible number would be 99999999.99

More Related Contents:

  1. Export from SQL Server to Excel
  2. If condition in SQL Server 2008
  3. Comma separated results in SQL
  4. Understanding PIVOT function in T-SQL
  5. Which are more performant, CTE or temporary tables?
  6. Using RegEx in SQL Server
  7. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  8. Import Excel spreadsheet columns into SQL Server database
  9. SqlServer: Login failed for user
  10. SQL Server 2008 Empty String vs. Space
  11. How do I use the CONCAT function in SQL Server 2008 R2?
  12. How can I automate the “generate scripts” task in SQL Server Management Studio 2008?
  13. Is it possible to force row level locking in SQL Server?
  14. Select / Insert version of an Upsert: is there a design pattern for high concurrency?
  15. How do I get date/time information from a TIMESTAMP column?
  16. How to drop column with constraint?
  17. SQL Server: combining multiple rows into one row
  18. How to add xml encoding to xml Output in SQL Server
  19. SQL Server GUID sort algorithm. Why?
  20. What happens to the primary key Id when it goes over the limit?
  21. SQL Recursive CTE: Finding objects linked by property
  22. Convert decimal time to hours and minutes
  23. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  24. Sort Bullets in Database
  25. Unable to login to SQL Server + SQL Server Authentication + Error: 18456
  26. What’s the best way to store co-ordinates (longitude/latitude, from Google Maps) in SQL Server?
  27. How Can I Detect and Bound Changes Between Row Values in a SQL Table?
  28. How to wait for 2 seconds?
  29. Find broken objects in SQL Server
  30. Populate Dataset With Table Names From Stored Procedure

Leave a Comment