I am going to start a series of very short articles or tidbits on Transaction SQL Operators. An operator is a symbol specifying an action that is performed on one or more expressions.
I will exploring the Arithmetic Operators today.
The very first practical use of modern day computers was to solve mathematical problems. The ENIAC computer in 1946 was used by the United States Army to create artillery firing tables.
TSQL supports the following five basic operations: addition, subtraction, multiplication, division and modulus.
Most people know the first four mathematical operations by heart. A modulo operation is defined as the as the whole number remainder after division is performed.
The example below performs a simple calculation using each operator.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
-- -- Arithmetic operators -- -- Addition select 1+2 as addition -- Subtraction select 3-1 as substraction -- Multiplication select 3*2 as multiplication -- Division select 6/3 as division -- Modulo select 12/5 as modulo |
The output of each calculation is listed below.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
output: addition ----------- 3 substraction ----------- 2 multiplication -------------- 6 division ----------- 2 modulo ----------- 2 |
Please note that there is a precedence order when it comes to operator evaluation. We will dive into those details in a later talk.
Next time, I will be exploring the Assignment Operator.
