FROM, SQL Simantics

SQL Server’s CROSS APPLY and how to use it

Randy Sims SQL Server

CROSS APPLY is a beautiful alternative for your FROM clause. It isn’t JOINed to anything but it can be correlated to other fields in your query. It also allows for an aggregate to be run on a row-by-row basis. CROSS APPLY can be very useful, and the following will show you what it is and […]

The Capabilities of a SQL SELECT Statement

Randy Sims SQL Fundamentals I

Exam Topic: Retrieving Data Using the SQL SELECT Statement – List the capabilities of SQL SELECT statements By far, the most important skill for anyone to possess when working with a database is the skill to extract from the database the data you want in the format you desire. The SELECT statement, therefore, is the most important […]