---
title: "Arithmetic Operators (Transact-SQL)"
description: "Arithmetic Operators (Transact-SQL)"
author: rwestMSFT
ms.author: randolphwest
ms.reviewer: ""
ms.date: "07/06/2017"
ms.prod: sql
ms.prod_service: "database-engine, sql-database, synapse-analytics, pdw"
ms.technology: t-sql
ms.topic: reference
ms.custom: ""
helpviewer_keywords:
  - "operators [Transact-SQL], arithmetic"
  - "arithmetic operators"
  - "math operations [Transact-SQL]"
dev_langs:
  - "TSQL"
monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqldb-mi-current"
---
# Arithmetic Operators (Transact-SQL)
[!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]

Arithmetic operators run mathematical operations on two expressions of one or more data types. They're run from the numeric data type category. For more information about data type categories, see [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md).  
  
|Operator|Meaning|  
|--------------|-------------|  
|[+ (Add)](../../t-sql/language-elements/add-transact-sql.md)|Addition|  
|[- (Subtract)](../../t-sql/language-elements/subtract-transact-sql.md)|Subtraction|  
|[* (Multiply)](../../t-sql/language-elements/multiply-transact-sql.md)|Multiplication|  
|[/ (Divide)](../../t-sql/language-elements/divide-transact-sql.md)|Division|  
|[% (Modulo)](../../t-sql/language-elements/modulo-transact-sql.md)|Returns the integer remainder of a division. For example, 12 % 5 = 2 because the remainder of 12 divided by 5 is 2.|  
  
The plus (+) and minus (-) operators can also be used to run arithmetic operations on **datetime** and **smalldatetime** values.  
  
For more information about the precision and scale of an arithmetic operation result, see [Precision, Scale, and Length (Transact-SQL)](../../t-sql/data-types/precision-scale-and-length-transact-sql.md).  
  
## See Also  
[Mathematical Functions (Transact-SQL)](../../t-sql/functions/mathematical-functions-transact-sql.md)   
[Data Types (Transact-SQL)](../../t-sql/data-types/data-types-transact-sql.md)   
[Expressions (Transact-SQL)](../../t-sql/language-elements/expressions-transact-sql.md)