Unsupported expressions

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

• Entity SQL Overview
• How Entity SQL Differs from Transact-SQL