Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - Rules on Arithmetic Operations
(Continued from previous topic...)
What Are Arithmetic Operators?
An arithmetic operator performs an arithmetic operation on two expressions of numeric data types.
SQL Server supports 5 arithmetic operators:
- + (Add): Addition
- - (Subtract): Subtraction
- * (Multiply): Multiplication
- / (Divide): Division
- % (Modulo): Modulation
There are several rules on arithmetic operations:
- Arithmetic operations are performed on expressions of numeric data types like INT, NUMERIC, and FLOAT.
- When arithmetic operations are performed on expressions of the same data types, no data type conversion is needed.
- When arithmetic operations are performed on expressions of different data types, implicit data type conversion
will be performed before the arithmetic operation on the expression with a lower data type rank.
- Numeric data type ranks are from low to high: TINYINT, SMALLINT, INT, BIGINT, SMALLMONEY, MONEY, DECIMAL, and FLOAT.
- The data type of the resulting value of an arithmetic operation is the same as the two input expressions.
(Continued on next topic...)
- What Is an Expression?
- What Are Arithmetic Operators?
- What Happens to an Arithmetic Operation with Two Different Data Types?
- How To Convert a Numeric Expression from One Data Type to Another?
- How To Convert Numeric Expression Data Types by Assignment Operations?
- How To Convert Numeric Expression Data Types using the CAST() Function?
- How To Convert Numeric Expression Data Types using the CONVERT() Function?
- How To Convert Character Strings into Numeric Values?
- What Happens When Converting Big Values to Integers?
- What Happens When Converting Big Values to NUMERIC Data Types?
- What Are the Mathematical Functions Supported by SQL Server 2005?
- How To Convert Numeric Values to Integers?
- How To Round a Numeric Value To a Specific Precision?
- How To Generate Random Numbers with the RAND() Function?