SQL Server: When We Use Cross or Outer Apply Instead of Simple Joins

APPLY statements are introduced in SQL SERVER 2005. 

I think most of us are use to with common JOIN statements. APPLY statements are just like these JOIN statements. 

CROSS APPLY is just like INNER JOIN and OUTER APPLY is just like LEFT OUTER JOIN.

Difference is very simple. 

When both joining members are simple tables, we use JOIN, but when one of joining member is parametrized table valued function, and there is no possibility to use ON clause, we use APPLY statements for joining.

Arshad Ali has explained it nicely with examples.

Collapsed Container in VFP

http://expertsoftwarecompany.wordpress.com/2012/12/22/collapsed-containter-in-vfp/

Un site gratuit pentru promovare site-urilor

O pagina, http://trafic-site.ro, care face schimb de trafic pentru promovarea mai rapida a site-urilor personale.

Programul de contabilitate ICAS, este pregatit pentru aplicarea sistemului "Tva la Incasare"

http://expertsoft.eu/news.php?extend.71.2

Reversing Forum Romania - Comunitatea dezvoltatorilor de aplicatii din Romania

Reversing Forum Romania
Comunitatea dezvoltatorilor de aplicatii din Romania.
http://reversing.ro

Inaltime minima a unui rand dintr-un grid

Pentru a acoperi toate situatiile posibile (daca se foloseste temele din windows, inaltimea minima creste cu 1 pixel fata de cea din documentatie, daca se schimba Zoom-ul (100%, 125%, 150%)  in Se7en)

nMinimRowHeight =  SysMetric(15) + 3.

De cat timp este pornit calculatorul

Declare Integer StrFromTimeInterval In Shlwapi;
String @ pszOut, Integer cchMax, Integer dwTimeMS, Integer digits

Declare Integer GetTickCount In kernel32
nIni = GetTickCount()

cSalida = Space(50)

=StrFromTimeInterval (@cSalida, Len(cSalida), nIni, 10)
Wait Window cSalida