Reading Time: 4 minutes The IS NULL predicate is a very useful thing to know when it comes to querying data and working with columns containing NULL. In this very brief tutorial, we’ll talk about why you need to use IS NULL instead of something like “= NULL” when checking if a value contains Continue Reading
SQL IF EXISTS Decision Structure: Explained with Examples
Reading Time: 6 minutes The SQL IF EXISTS tool is great to know for managing the flow of control of your SQL code. In this very brief tutorial, we’ll discuss everything you need to know about the IF EXISTS decision structure in SQL Server. We’ll discuss these topics: What is the SQL IF EXISTS Continue Reading