CROSS APPLY (equivalent to an inner join):
OUTER APPLY (equivalent to a left join):
Note that any object with no parameter or column will not have an any records in the syscolumns table (eg, SPROCs with no parameters).
Mike's a long-time, C# developer, with experience in database development, software architecture & design, .Net, ASP.NET, HTML, JavaScript, VB, CSS, Flash, SQL Server, Oracle, and more.
CROSS APPLY (equivalent to an inner join):
OUTER APPLY (equivalent to a left join):
Note that any object with no parameter or column will not have an any records in the syscolumns table (eg, SPROCs with no parameters).
1 comment:
I used in some queries and there was an improvement of 10seg less against the original code.
Thanks
Post a Comment