= (Assignment Operator) (Transact-SQL)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric
The equal sign (=) is the only Transact-SQL 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)
Opinia
https://aka.ms/ContentUserFeedback.
Dostępne już wkrótce: W 2024 r. będziemy stopniowo wycofywać zgłoszenia z serwisu GitHub jako mechanizm przesyłania opinii na temat zawartości i zastępować go nowym systemem opinii. Aby uzyskać więcej informacji, sprawdź:Prześlij i wyświetl opinię dla