tag:blogger.com,1999:blog-6082652835152798567.post9106759062606131993..comments2024-03-28T21:41:58.974-07:00Comments on Sql server, .net and c# video tutorial: Cross apply and outer apply in sql serverUnknownnoreply@blogger.comBlogger7125tag:blogger.com,1999:blog-6082652835152798567.post-91896755568788418392020-06-30T11:08:33.358-07:002020-06-30T11:08:33.358-07:00SELECT D.DepartmentName, E.Name,E.Gender,E.Salary
...SELECT D.DepartmentName, E.Name,E.Gender,E.Salary<br />FROM Department D<br />OUTER APPLY fn_GetEmployeesByDepartmentId(D.Id) Eblogspothttps://www.blogger.com/profile/03185026368070801616noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-29778719749699541102019-04-09T14:13:49.588-07:002019-04-09T14:13:49.588-07:00SELECT D.DepartmentName, E.Name,E.Gender,E.Salary
...SELECT D.DepartmentName, E.Name,E.Gender,E.Salary<br />FROM Employee E<br />RIGHT JOIN Department D<br />ON E.DepartmentId = D.Id<br /><br />HOW to Apply OUTER APPLY JOIN on this<br />Aqibhttps://www.blogger.com/profile/01776836004089242428noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-85233777541351790862018-12-14T02:04:44.366-08:002018-12-14T02:04:44.366-08:00You say outer apply is semantically equivalent to ...You say outer apply is semantically equivalent to left outer join can you draw the same parallel with right outer join?Anonymoushttps://www.blogger.com/profile/11514371966101944882noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-47538430093274988892015-12-17T08:58:10.455-08:002015-12-17T08:58:10.455-08:00OUTER JOIN IS 3 THREE TYPES.
LEFT OUTER JOIN
RIGHT...OUTER JOIN IS 3 THREE TYPES.<br />LEFT OUTER JOIN<br />RIGHT OUTER JOIN<br /><br />FULL OUTER JOIN.<br /><br />THERE IS NO DIFFERENCE BETWEEN LEFT JOIN AND LEFT OUTER JOIN.<br />I HOPE IT CLEARS YOUR DOUBT.<br />Anonymoushttps://www.blogger.com/profile/14310028441249893908noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-78990884754884988072015-11-24T15:48:39.477-08:002015-11-24T15:48:39.477-08:00Hi Venkat,
In the above Outer Apply you have menti...Hi Venkat,<br />In the above Outer Apply you have mentioned it is same as left outer join. Any specific reason why you have mentioned left "OUTER" join. Left join and left outer join are the same. Please correct me. Bhargavahttps://www.blogger.com/profile/10497830069361676960noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-85962108882071074572015-09-09T00:39:47.889-07:002015-09-09T00:39:47.889-07:00Thank you very much for great video tutorial.This ...Thank you very much for great video tutorial.This is very helpful to me and others also .My request is also upload the videos of OVER ( ) CLAUSE and Partition also Thank You...!!!!Nawaraj Subedinoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-17493757640843250432015-09-08T13:37:06.987-07:002015-09-08T13:37:06.987-07:00Please discuss Sequence in SqlServerPlease discuss Sequence in SqlServerAnonymousnoreply@blogger.com