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, 1823👍, 0💬
Popular Posts:
How To Create a Test Table for Transaction Testing in Oracle? If you want to practice DML statements...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Create a Stored Function in Oracle? A stored function is a function with a specified name and...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...