Tag Archives: sql

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 It is similar to an INNER JOIN i.e. It returns rows from the left table that have a matching row in the right table. NoContinue reading “Understanding Microsoft SQL CROSS APPLY and OUTER APPLY Operators”