Arithmetic operators perform mathematical operations within Transact-SQL statements.
These are the arithmetic operators:
| Symbol | Meaning | Can be used with | |
|---|---|---|---|
| + | Addition | int, smallint, tinyint, numeric, decimal, float, real, money, and smallmoney | |
| - | Subtraction | int, smallint, tinyint, numeric, decimal, float, real, money, and smallmoney | |
| * | Multiplication | int, smallint, tinyint, numeric, decimal, float, real, money, and smallmoney | |
| / | Division | int, smallint, tinyint, numeric, decimal, float, real, money, and smallmoney | |
| % | Modulo* | int, smallint, and tinyint | |
| * A modulo is the integer remainder after a division involving two integers. For example, 21 % 9 = 3 because 21 divided by 9 equals 2 with a remainder of 3. |
|||