/= (Divide EQUALS) (Transact-SQL)

/= (Divide EQUALS) (Transact-SQL)

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All

Language Filter

SQL Server 2008 Books Online (October 2009)

/= (Divide EQUALS) (Transact-SQL)

Divides one number by another and sets a value to the result of the operation. For example, if a variable @x equals 34, then @x /= 2 takes the original value of @x, divides by 2 and sets @x to that new value (17).

Topic link icon Transact-SQL Syntax Conventions

Syntax

expression /= expression

Arguments

expression: Is any valid expression of any one of the data types in the numeric category except the bit data type.

Remarks

For more information, see / (Divide) (Transact-SQL).

Result Types

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

Reference

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

Help and Information

Getting SQL Server 2008 Assistance