Export (0) Print
Expand All
Expand Minimize

- (Negative) (Transact-SQL)

Returns the negative of the value of a numeric expression (a unary operator).

Topic link icon Transact-SQL Syntax Conventions


- numeric_expression

numeric_expression

Is any valid expression of any one of the data types of the numeric data type category, except the date and time category.

Returns the data type of numeric_expression, except that an unsigned tinyint expression is promoted to a signed smallint result.

A. Setting a variable to a negative value

The following example sets a variable to a negative value.

USE tempdb;
GO
DECLARE @MyNumber decimal(10,2);
SET @MyNumber = -123.45;
SELECT @MyNumber;
GO

B. Changing a variable to a negative value

The following example changes a variable to a negative value.

USE tempdb;
GO
DECLARE @Num1 int;
SET @Num1 = 5;
SELECT -@Num1;
GO

Community Additions

ADD
Show:
© 2014 Microsoft