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).
.gif)
Transact-SQL Syntax Conventions
-
expression
-
Is any valid expression of any one of the data types in the numeric category except the bit data type.
For more information, see / (Divide) (Transact-SQL).
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