Collections:
CONVERT() - Converting Numeric Expression Data Types in SQL Server
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL?
✍: FYIcenter.com
If you want to convert the data type of a numeric expression to a new data type, you can use the CONVERT(data_type, expression) function. The tutorial exercise below shows you how to use the CONVERT() function:
-- FLOAT converted to NUMERIC by CONVERT() DECLARE @pi FLOAT(24); SET @pi = 3.141592E+00; SELECT CONVERT(NUMERIC(5,2), @pi); GO 3.14 -- FLOAT converted to NUMERIC by CONVERT() DECLARE @x FLOAT(24); SET @x = 12345.12E+00; SELECT CONVERT(NUMERIC(10,5), @x); GO 12345.12012 -- FLOAT converted to INT by CONVERT() DECLARE @x FLOAT(24); SET @x = 12345.12E+00; SELECT CONVERT(INT, @x); GO 12345
⇒ CONVERT() - Converting Character Strings to Numeric Values in SQL Server
⇐ CAST() - Converting Numeric Expression Data Types in SQL Server
⇑ Numeric Expressions and Functions in SQL Server Transact-SQL
2017-03-27, 3723🔥, 0💬
Popular Posts:
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...