Monthly Archives: October 2006

IN and NOT IN operators with NULL value

When we use "IN" and "NOT IN" operator, we need to be very carefull if the subquery contains NULL value. The record set returnd "IN" plus "NOT IN" does not equal the record set without the condition. Let’s first take … Continue reading

Posted in SQL server | Leave a comment