SQL Server: When We Use Cross or Outer Apply Instead of Simple Joins (connectsql.blogspot.com)

submitted by lionofdezertlionofdezert(1110) 1 year, 3 months ago

APPLY statements are used for joining purpose just like simple JOIN statements. Cross Apply is just like INNER JOIN and Outer APPLY is just like LEFT OUTER JOIN.

add a comment |category: |Views: 28

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
Comments:
information Login or create an account to comment on this story