Table Expressions Flashcards
1
Q
What supported types of Apply does SQL Server support?
A
CROSS APPLY & OUTER APPLY
2
Q
True or False:
The CROSS APPLY operator implements one logical-query processing phase.
A
True
It APPLIES the right table TO EACH ROW from the left table AND PRODUCES a result table with unified result sets.