- (Negative) (Transact-SQL)

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

Transact-SQL Syntax Conventions

Składnia

- numeric_expression

Arguments

• 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.

Result Types

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

Examples

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

Zobacz także

Odwołanie

Data Types (Transact-SQL)

Expressions (Transact-SQL)

Operators (Transact-SQL)