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
⇒Numeric Expressions and Functions in SQL Server Transact-SQL
2017-03-27, 1723👍, 0💬
Popular Posts:
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...