Collections:
CAST() - Converting Numeric Expression Data Types in SQL Server
How To Convert Numeric Expression Data Types using the CAST() 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 CAST(expression AS data_type) function. The tutorial exercise below shows you how to use the CAST() function:
-- FLOAT converted to NUMERIC by CAST() DECLARE @pi FLOAT(24); SET @pi = 3.141592E+00; SELECT CAST(@pi AS NUMERIC(5,2)); GO 3.14 -- FLOAT converted to NUMERIC by CAST() DECLARE @x FLOAT(24); SET @x = 12345.12E+00; SELECT CAST(@x AS NUMERIC(10,5)); GO 12345.12305 -- FLOAT converted to INT by CAST() DECLARE @x FLOAT(24); SET @x = 12345.12E+00; SELECT CAST(@x AS INT); GO 12345
⇒ CONVERT() - Converting Numeric Expression Data Types in SQL Server
⇐ Converting Numeric Data Types by Assignment Operations in SQL Server
⇑ Numeric Expressions and Functions in SQL Server Transact-SQL
2017-03-27, 3132🔥, 0💬
Popular Posts:
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...