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, 5116🔥, 0💬
Popular Posts:
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...