Table Expressions

Question 1

What supported types of Apply does SQL Server support?

Answer 1

CROSS APPLY & OUTER APPLY

Question 2

True or False:

The CROSS APPLY operator implements one logical-query processing phase.

Answer 2

True

It APPLIES the right table TO EACH ROW from the left table AND PRODUCES a result table with unified result sets.