Free SQL Video : SQL Server NOT IN clause not working

Hi Friends,

In this video, I am demonstrating a specific behavior of SQL Server NOT IN clause not working when dealing with NULLs!

Get new content directly in your inbox – Click here

You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code).

Hope the video was worth your time.

Happy Learning.

Learn more about SQLMaestros Products & Services: Video Courses| Hands-On-Labs | Learning Kits | Health Check Service

By Amit Bansal|2023-02-09T17:09:21+05:30September 8th, 2014|SQL Server|3 Comments

About the Author: Amit Bansal

Amit Bansal is always brainstorming around SQL Server. Despite working with SQL since 1997, he is amazed that he keeps learning new things every single day. SQL Server is AB's first love, and his wife does not mind that. He tries to share as much and spreads the SQL goodness. Internals and Performance Tuning excites him, and also gives him sleepless nights at times, simply because he is not a genius, but quite a hard worker and does not give up. It has been a long and exciting journey since 1997, you can read here: https://sqlmaestros.com/amit-bansal/ He is on Twitter: https://www.twitter.com/A_Bansal

3 Comments

Calin September 8, 2014 at 3:56 pm - Reply
Amit,
perhaps you should also mention EXISTS, and, more importantly, NOT EXISTS, as it is dealing purely with two-predicate logic, so it simply ignores NULLs. In that sense, for this simple demo, it might perform better, and with a simpler code.
best regards
- Amit Bansal September 8, 2014 at 5:18 pm - Reply
  Hi Calin, i did talk abt not exisits but did not show the code piece. I shall append the code piece tomorrow. Thanks !
Amit Bansal September 15, 2014 at 9:50 pm - Reply
Hi Calin, blog updated 🙂 – https://www.sqlmaestros.com/sql-server-not-in-clause-not-working/

Free SQL Video : SQL Server NOT IN clause not working