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
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
Hi Calin, i did talk abt not exisits but did not show the code piece. I shall append the code piece tomorrow. Thanks !
Hi Calin, blog updated 🙂 – https://www.sqlmaestros.com/sql-server-not-in-clause-not-working/