sql cross apply

SQL Cross Apply and Outer Apply: The Complete Guide

Have you heard of the SQL Cross Apply feature but have no idea what it does? Or are you familiar with how both Cross Apply and Outer Apply work but don’t know how they can work in the real world? Learn all about them in this guide.

sql update from select

How to Update from Select in SQL

It’s possible to update data in one table based on the results of another table or query. Learn how to do it in this guide.

sql bind variables

A Guide to SQL Bind Variables

Bind variables are a great feature in SQL and have many benefits. Learn how to use them in several vendors in this article.