Skip to content
Simple SQL Tutorials

Simple SQL Tutorials

Your guide to querying and developing SQL Server databases

  • Home
  • Tutorials
    • The Basics
    • Transactions
    • Normalization
    • Querying data
    • Developing Databases
    • SQL Questions
    • Identity Property
    • JOIN
    • Data Types
    • Stored Procedures
    • Window functions
    • Data Definition Language
    • Views
    • Constraints
    • Set Operators
    • Table Expressions
    • Error Handling
    • Functions
    • Indexes
    • Triggers
  • Products
  • Contact
  • Privacy Policy
  • About

SQL Server IS NULL: Why can’t I just use “= NULL”?

Posted on March 21, 2022August 16, 2023 by Josh D
SQL Server IS NULL: Why can’t I just use “= NULL”?

Reading Time: 4 minutesThe 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

Posted In SQL Questions

SQL IF EXISTS Decision Structure: Explained with Examples

Posted on March 21, 2022August 16, 2023 by Josh D
SQL IF EXISTS Decision Structure: Explained with Examples

Reading Time: 6 minutesThe 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

Posted In Data Definition Language, The Basics

Tutorial Categories

Navigation:

Home » 2022 » 03 » 21

Sign up for our newsletter!

Recent Posts

  • “Why should I save my query as a View instead of a .SQL file?” Answered!
  • SQL Server DELETE vs. TRUNCATE: What’s the difference?
  • SQL Server COALESCE System Function: How It Works
  • Can we create indexes in table variables? YES WE CAN!
  • SQL Server WINDOW Clause: Explained!
Copyright All rights reserved | Theme: Flash Blog by Unitedtheme.
SimpleSQLTutorials.com uses cookies to provide the best experience on our website through tailored advertising. By clicking Accept, you agree to our use of cookies.AcceptPrivacy policy