Export (0) Print
Expand All

[NOT] EXISTS

Determines if a collection is empty.


[NOT] EXISTS (expression)

expression
Any valid expression that returns a collection.

NOT
Specifies that the result of EXISTS be negated.

true if the collection is not empty; otherwise, false.

EXISTS is one of the Entity SQL set operators. All Entity SQL set operators are evaluated from left to right. For precedence information for the Entity SQL set operators, see EXCEPT.

The following Entity SQL query uses the EXISTS operator to determine whether the collection is empty. 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 name from AdventureWorksEntities.Products
AS name where exists(SELECT A from AdventureWorksEntities.Products
as A WHERE A.ListPrice < @price1)
    




Build Date:

2012-10-01
Show:
© 2015 Microsoft