assignment-operator-transact-sql.md

title	= (Assignment Operator) (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database, sql-data-warehouse, pdw
ms.reviewer
ms.technology	t-sql
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	operators [Transact-SQL], assignment assignment operators [Transact-SQL] headings [SQL Server columns] relationships [SQL Server], assignment operators column headings [SQL Server]
ms.assetid	c3040db6-21d6-40ac-a783-82c98ec006cc
author	rothja
ms.author	jroth
monikerRange	>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

= (Assignment Operator) (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-all_md]

The equal sign (=) is the only [!INCLUDEtsql] assignment operator. In the following example, the @MyCounter variable is created, and then the assignment operator sets @MyCounter to a value returned by an expression.

DECLARE @MyCounter INT;  
SET @MyCounter = 1;  

The assignment operator can also be used to establish the relationship between a column heading and the expression that defines the values for the column. The following example displays the column headings FirstColumnHeading and SecondColumnHeading. The string xyz is displayed in the FirstColumnHeading column heading for all rows. Then, each product ID from the Product table is listed in the SecondColumnHeading column heading.

-- Uses AdventureWorks  
  
SELECT FirstColumnHeading = 'xyz',  
       SecondColumnHeading = ProductID  
FROM Production.Product;  
GO  

See Also

Operators (Transact-SQL)
Compound Operators (Transact-SQL)
Expressions (Transact-SQL)