Collections:
NULL Values Involved in Arithmetic Operations in SQL Server
What Happens If NULL Values Are Involved in Arithmetic Operations in SQL Server Transact-SQL?
✍: FYIcenter.com
If NULL values are involved in arithmetic operations, the result will be numeric NULL values. The following tutorial script shows you some good examples:
SELECT 7+NULL; GO ----------- NULL SELECT 10.02*NULL; GO ----------- NULL SELECT 4.988E+10/NULL; GO ----------- NULL
2017-02-05, 718👍, 0💬
Popular Posts:
How To Create a Test Table for Transaction Testing in Oracle? If you want to practice DML statements...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...