Skip to content

multiply-equals-transact-sql.md

Latest commit

 

History

History
58 lines (46 loc) · 2.38 KB

multiply-equals-transact-sql.md

File metadata and controls

58 lines (46 loc) · 2.38 KB
description *= (Multiplication Assignment) (Transact-SQL)
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 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 cawrites
ms.author chadam
monikerRange >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

*= (Multiplication Assignment) (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi-asa-pdw]

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

[!INCLUDEsql-server-tsql-previous-offline-documentation]

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)