About this tutorial:
Video duration: 8:16
cross apply sql server example
sql server outer apply example
sql server join table function with parameter
sql server inner join table valued function
In this video we will discuss cross apply and outer apply in sql server with examples.
We want to retrieve all the matching rows between Department and Employee tables.
This can be very easily achieved using an Inner Join as shown below.
Select D.DepartmentName, E.Name, E.Gender, E.Salary
from Department D
Inner Join Employee E
On D.Id = E.DepartmentId
Now if we want to retrieve all the matching rows between Department and Employee…