CROSS APPLY vs INNER JOIN vs LEFT JOIN vs OUTER APPLY

JOIN and APPLY

CROSS APPLY vs INNER JOIN vs LEFT JOIN vs OUTER APPLY So you want to improve your SQL skills and have come across some new operators like JOIN and APPLY and are wondering when you should use them. In this blog, I will focus on the following operators in the simplest terms and show you …

JOIN and APPLY Read More »

SQL Server Functions

SQL Server Functions

SQL Server Functions Sometimes you read books on subjects about SQL Server and you just want to learn the basics, well here are the basics of SQL Server Functions Functions can be Scalar or Table-valued Scalar returns one value and Table-valued functions (TVF) returns…well a table of results and this are usually found in the …

SQL Server Functions Read More »