Write a number with two decimal places SQL Server

by

Try this

SELECT CONVERT(DECIMAL(10,2),YOURCOLUMN)

such as

SELECT CONVERT(DECIMAL(10,2),2.999999)

will result in output 3.00

enter image description here

More Related Contents:

  1. Convert text to system date format [duplicate]
  2. How to get a particular preceding value of a column in SQL [closed]
  3. Syntax not valid on word ‘ON’ in SQL join statement [closed]
  4. Need SQL Script
  5. SQL update from one Table to another based on a ID match
  6. SQL JOIN vs IN performance?
  7. Can a foreign key be NULL and/or duplicate?
  8. TSQL Pivot without aggregate function
  9. How to generate a range of dates in SQL Server
  10. SQL RANK() versus ROW_NUMBER()
  11. Why are there gaps in my IDENTITY column values?
  12. Check if a row exists, otherwise insert
  13. Export SQL query data to Excel
  14. How can I do a BEFORE UPDATED trigger with sql server?
  15. How do I pass a list as a parameter in a stored procedure?
  16. SQL SERVER: Get total days between two dates
  17. Alter user defined type in SQL Server
  18. Deferrable Constraints in SQL Server
  19. Store multiple bit values in a single table column
  20. SQL Server equivalent to MySQL enum data type?
  21. How do I loop through a set of records in SQL Server?
  22. Create parameterized VIEW in SQL Server 2008
  23. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  24. Group All Related Records in Many to Many Relationship, SQL graph connected components
  25. SQL Server SELECT INTO @variable?
  26. Select a column if other column is null
  27. How to subtract 30 days from the current date using SQL Server
  28. Use one CTE many times
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment