Collections:
FLOOR, CEILING, ROUND - Converting Values to Integers in SQL Server
How To Convert Numeric Values to Integers in SQL Server Transact-SQL?
✍: FYIcenter.com
Sometimes you need to round a numeric value into an integer. SQL Server 2005 offers you a number of ways to do this:
The tutorial exercise below gives some good examples of converting numeric values to integers:
SELECT FLOOR(1234.5678); SELECT CEILING(1234.5678); SELECT ROUND(1234.5678, 0, 0); SELECT CAST(1234.5678 AS INT); SELECT CONVERT(INT, 1234.5678); GO 1234 1235 1235.0000 1234 1234
⇒ ROUND() - Rounding Values to Specific Precisions in SQL Server
⇐ Mathematical Functions Supported by SQL Server 2005 in SQL Server
⇑ Numeric Expressions and Functions in SQL Server Transact-SQL
2017-03-22, 5888🔥, 0💬
Popular Posts:
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...