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. |