差异B / W交叉连接和交叉应用？ [英] Difference B/w cross join and cross Apply?

问题描述

select * from Emp e1
cross join  Dep d
go

select * from Emp e1
cross apply Dep d
go

推荐答案

HI，



查看此链接，这将对您有所帮助。



http://www.sqlservercentral.com/Forums/Topic843768 -8-1.aspx [ ^ ]



HTTP：//www.mssqltip s.com/sqlservertip/1958/sql-server-cross-apply-and-outer-apply/ [ ^ ]



http://stackoverflow.com/questions/1139160/when-should-i-use -cross-apply-over-inner-join [ ^ ]





http://www.experts-exchange.com/Database/MS-SQL-Server/SQL- Server-2005 / Q_28434732.html [ ^ ]

Check this links this will help you.

http://www.sqlservercentral.com/Forums/Topic843768-8-1.aspx[^]

http://www.mssqltips.com/sqlservertip/1958/sql-server-cross-apply-and-outer-apply/[^]

http://stackoverflow.com/questions/1139160/when-should-i-use-cross-apply-over-inner-join[^]


http://www.experts-exchange.com/Database/MS-SQL-Server/SQL-Server-2005/Q_28434732.html[^]

这篇关于差异B / W交叉连接和交叉应用？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！