How can I round a value in SQL

by

ROUND documentation on MSDN

select
  [raw]       = 555.81, 
  [rounded]   = round(555.81, 0),
  [truncated] = round(555.81, 0, 1)

Result:

|    raw | rounded | truncated |
|--------|---------|-----------|
| 555.81 |     556 |       555 |

SQL Fiddle: http://sqlfiddle.com/#!6/9eecb7db59d16c80417c72d1/5290

More Related Contents:

  1. How do I update a value in C# and SQL Server? [closed]
  2. SQL Server Char/VarChar DateTime Error [closed]
  3. Delete from two tables? [closed]
  4. Adding multiple parameterized variables to a database in c#
  5. Insert entire DataTable into database at once instead of row by row?
  6. Getting return value from stored procedure in C#
  7. SQL error: Incorrect syntax near the keyword ‘User’
  8. What represents a double in sql server?
  9. Passing List to SQL Stored Procedure
  10. Query extremely slow in code but fast in SSMS
  11. How to retrieve data from a SQL Server database in C#?
  12. Code to validate SQL Scripts
  13. Any way to SQLBulkCopy “insert or update if exists”?
  14. SQLException : String or binary data would be truncated
  15. Multi threading C# application with SQL Server database calls
  16. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  17. Generate class from database table
  18. ALTER TABLE DROP COLUMN failed because one or more objects access this column
  19. When executing a stored procedure, what is the benefit of using CommandType.StoredProcedure versus using CommandType.Text?
  20. Can I use ADFS 2.0 to authenticate certain users against SQL Server?
  21. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  22. What is passing parameters to SQL and why do I need it?
  23. Add WHERE clauses to SQL dynamically / programmatically
  24. How to pass string array in SQL parameter to IN clause in SQL
  25. How to pass a null variable to a SQL Stored Procedure from C#.net code
  26. How to insert data into SQL Server
  27. Query validation using C#
  28. Database Error: There is no row at position 0
  29. Generating sql code programmatically
  30. Capturing count from an SQL query

Leave a Comment