Expert Software Company : News

duminică, 27 octombrie 2013

Robin Thicke - Blurred Lines ft. T.I., Pharrell

vineri, 12 aprilie 2013

Burkhard's VFP Blog: Cool VFP Event Binding

Burkhard's VFP Blog: Cool VFP Event Binding: Back to the golden thread! Let’s use the form we already created for our first test-drive. I saved it under a new name “LOGIN.SCX”. Below there are two screenshots showing the login form’s GUI layout in development mode and at runtime:

joi, 10 ianuarie 2013

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.