TechNet
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize
The document is archived and information here might be outdated

+ (Positive) (SQL Server Compact Edition)

Is a unary operator that returns the positive value of a numeric expression.


+ numeric_expression

numeric_expression

Any valid expression in Microsoft SQL Server 2005 Compact Edition of any of the data types in the numeric data type category, except the datetime data type.

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

The following examples use the Orders table to show how the positive and negative unary operators function. When a positive unary operator is set against a negative value, the returned value is negative (positive_value * negative_value = negative_value). When a negative unary operator is set against a negative value, the returned value is positive (negative_value * negative_value = positive_value).

SELECT (DATEPART(day, OrderDate) - DATEPART(day, ShippedDate)) FROM Orders WHERE OrderID = '10248'
--Without a unary operator, the value returned is '-12'.

SELECT +(DATEPART(day, OrderDate) - DATEPART(day, ShippedDate)) FROM Orders WHERE OrderID = '10248'
--With the positive unary operator, the value returned is '-12'.

SELECT -(DATEPART(day, OrderDate) - DATEPART(day, ShippedDate)) FROM Orders WHERE OrderID = '10248'
--With the negative unary operator, the value returned is '12'.
Show:
© 2016 Microsoft