Skip to content

multiply-equals-transact-sql.md

Latest commit

 

History

History
55 lines (44 loc) · 2.22 KB

multiply-equals-transact-sql.md

File metadata and controls

55 lines (44 loc) · 2.22 KB
title *= (Multiplication Assignment) (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 03/06/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
f1_keywords
*=_TSQL
*=
dev_langs
TSQL
helpviewer_keywords
compound operators, *=
assignment operators, *=
augmented operators, *=
*= (multiply equals)
*= (multiplication assignment)
ms.assetid 816ff5dc-9a40-4c07-8351-39c194dbc079
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

*= (Multiplication Assignment) (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-all_md]

Multiplies two numbers and sets a value to the result of the operation. For example, if a variable @x equals 35, then @x *= 2 takes the original value of @x, multiplies by 2 and sets @x to that new value (70).

Topic link icon Transact-SQL Syntax Conventions

Syntax

expression *= expression

Arguments

expression
Is any valid data type expression, except the bit type, in the numeric category.

Result Types

Returns the data type of the argument with the higher precedence. For more information, see Data Type Precedence (Transact-SQL).

Remarks

For more information, see * (Multiplication) (Transact-SQL).

See Also

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