Collections:
Converting Numeric Expressions from One Data Type to Another in SQL Server
How To Convert a Numeric Expression from One Data Type to Another in SQL Server Transact-SQL?
✍: FYIcenter.com
There are 4 ways to convert a numeric expression from one data type to another data type:
Some numeric data type conversion examples are provided in the tutorial exercise below:
-- Implicit conversion by an arithmetic operation -- INT converted to NUMERIC DECLARE @d NUMERIC(9,6); SET @d = 1.0; SELECT @d/3; GO 0.33333333 -- Implicit conversion by an assignment operation -- NUMERIC converted to INT DECLARE @i INT; DECLARE @d NUMERIC(9,3); SET @d = 123.456; SET @i = @d; SELECT @i; GO 123 -- Explicit conversion by CAST() -- FLOAT converted to NUMERIC DECLARE @pi FLOAT(24); SET @pi = 3.1415927E+00; SELECT CAST(@pi AS NUMERIC(5,2)); GO 3.14 -- Explicit conversion by CONVERT() -- FLOAT converted to NUMERIC DECLARE @pi FLOAT(24); SET @pi = 3.1415927E+00; SELECT CONVERT(NUMERIC(5,2), @pi); GO 3.14
⇒ Converting Numeric Data Types by Assignment Operations in SQL Server
⇐ Arithmetic Operations with Different Data Types in SQL Server
⇑ Numeric Expressions and Functions in SQL Server Transact-SQL
2017-03-27, 1480🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...