Collections:
Arithmetic Operations with Different Data Types in SQL Server
What Happens to an Arithmetic Operation with Two Different Data Types in SQL Server Transact-SQL?
✍: FYIcenter.com
When two expressions with different data types are put together for an arithmetic operation, the expression with a lower rank data type will be converted automatically to higher rank data type. Usually, a data type with a larger storage size has a higher rank. A conversion from a lower rank data type to a higher rank data type is considered safe, because there is no data lose during the conversion.
The tutorial exercise shows you some good examples on automatic conversion during arithmetic operations:
-- INT / INT, No conversion -- Returning INT DECLARE @i INT; SET @i = 1; SELECT @i/3; GO 0 -- NUMERIC / INT, INT converted to NUMERIC -- Returning NUMERIC DECLARE @d NUMERIC(9,6); SET @d = 1.0; SELECT @d/3; GO 0.33333333 -- INT * NUMERIC, INT converted to NUMERIC -- Returning NUMERIC DECLARE @pi NUMERIC(15,7); DECLARE @d INT; SET @pi = 3.1415927; SET @d = 10000000; SELECT @d*@pi; GO 31415927.0000000 -- INT * FLOAT, INT converted to FLOAT -- Returning FLOAT DECLARE @pi FLOAT(24); DECLARE @d INT; SET @pi = 3.1415927E+00; SET @d = 10000000; SELECT @d*@pi; -- @d converted from INT to FLOAT GO 3.141593E+07
⇒ Converting Numeric Expressions from One Data Type to Another in SQL Server
⇐ Rules on Arithmetic Operations in SQL Server
⇑ Numeric Expressions and Functions in SQL Server Transact-SQL
2017-03-27, 1477🔥, 0💬
Popular Posts:
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...