Unsupported Expressions

  • Article

This topic describes Transact-SQL expressions that are not supported in Entity SQL. For more information, see How Entity SQL Differs from Transact-SQL.

Quantified Predicates

Transact-SQL allows constructs of the following form:

sal > all (select salary from employees)
sal > any (select salary from employees)

Entity SQL, however, does not support such constructs. Equivalent expressions can be written in Entity SQL as follows:

not exists(select 0 from employees as e where sal > e.salary)
exists(select 0 from employees as e where sal > e.salary)

* Operator

Transact-SQL supports the use of the * operator in the SELECT clause to indicate that all columns should be projected out. This is not supported in Entity SQL.

See Also

Concepts

Entity SQL Overview
How Entity SQL Differs from Transact-SQL