Questions Tagged [cross-apply]

The T-SQL APPLY operator allows you to invoke a table-valued function for each row returned by an outer table expression of a query. CROSS APPLY acts as a replacement for an INNER JOIN and only returns rows if there is a match on the join condition. Using CROSS APPLY in some instances will perform better than an equivalent JOIN statement. It is similar to a `CROSS JOIN LATERAL` in the SQL standard

Question is empty. Ask new Question

Popular Questions

Top Members

Trending Tags

redux version-control ide rss line azure-ad-b2c bundler html-agility-pack abap orientdb statusbar implementation projection fwrite intentfilter one-to-one lua-table nonetype dotnetopenauth rounded-corners timezone-offset moss rmagick interstitial resourcebundle html-input drawimage recharts clip-path probability-density udf unobtrusive-javascript javaagents python-behave rollover discord-jda postman-collection-runner azure-queues mysql-real-escape-string desire2learn appveyor accounting azure-data-flow filepond twincat websphere-6.1 imbalanced-data range-v3 pygments webhdfs