Microsoft SQL has two variants i.e. CROSS APPLY and OUTER APPLY. Both operators are in SQL used to perform table-valued function /correlated subqueries against rows in another table. CROSS APPLY OUTER APPLY Points to consider:
This is a Personal Blog for SQL Database tips, tricks, news, about interview questions/answers and much more.
Microsoft SQL has two variants i.e. CROSS APPLY and OUTER APPLY. Both operators are in SQL used to perform table-valued function /correlated subqueries against rows in another table. CROSS APPLY OUTER APPLY Points to consider: