---
title: "Arithmetic Operators (Transact-SQL) | Microsoft Docs"
ms.custom: ""
ms.date: "07/06/2017"
ms.prod: "sql"
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
ms.service: ""
ms.component: "t-sql|language-elements"
ms.reviewer: ""
ms.suite: "sql"
ms.technology: 
  - "database-engine"
ms.tgt_pltfrm: ""
ms.topic: "language-reference"
dev_langs: 
  - "TSQL"
helpviewer_keywords: 
  - "operators [Transact-SQL], arithmetic"
  - "arithmetic operators"
  - "math operations [Transact-SQL]"
ms.assetid: a41b92a5-1061-4e4d-bb3b-a180b73c88fa
caps.latest.revision: 23
author: "douglaslMS"
ms.author: "douglasl"
manager: "craigg"
monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"
---
# Arithmetic Operators (Transact-SQL)
[!INCLUDE[tsql-appliesto-ss2008-all-md](../../includes/tsql-appliesto-ss2008-all-md.md)]

  Arithmetic operators perform mathematical operations on two expressions of one or more of the data types of 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 perform arithmetic operations on **datetime** and **smalldatetime** values.  
  
 For more information about the precision and scale of the result of an arithmetic operation, 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)