CROSS APPLY

Table-values constructor

Data modification statements

Combination of detailed and aggregated data

Getting summarizing values

CROSS APPLY / OUTER APPLY operators

New sql features