Table Expressions Flashcards

1
Q

What supported types of Apply does SQL Server support?

A

CROSS APPLY & OUTER APPLY

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly