Export (0) Print
Expand All

- (Subtract)

Subtracts two numbers.

expression-expression

expression
Any valid expression of any one of the numeric data types.

The data type that results from the implicit type promotion of the two arguments. For more information about implicit type promotion, see Type System.

The following Entity SQL query uses the - arithmetic operator to subtract two numbers. The query is based on the AdventureWorks Sales Model. To compile and run this query, follow these steps:

  1. Follow the procedure in How to: Execute a Query that Returns StructuralType Results.

  2. Pass the following query as an argument to the ExecuteStructuralTypeQuery method:


SELECT VALUE product FROM AdventureWorksEntities.Products
AS product where product.ListPrice = @price1 - @price2
    




Build Date:

2012-10-01
Show:
© 2014 Microsoft