This article explains different arithmetic operators available in SQL server with example.
Operator
Meaning
+ ( Add )
Addition
- ( Subtract )
Subtraction
* ( Multiply )
Multiplication
/ ( Divide )
Division
% ( Modulo )
Returns the integer remainder of a division. For example, 12 % 5 = 2 because the remainder of 12 divided by 5 is 2.