Free SQL Video : SQL Server NOT IN clause not working
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.
Share In Your Social Platform !
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
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.
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/