Often times NULLable columns cause havoc, if not handled in where clauses and in join conditions.
It would be very good if SQL Prompt can warn (like syntax error checking) if NULL is not handled for a NULLable column in join conditions or where clauses.
Note: Make sure to warn appropriately when ISNULL(field1, field2) is used. In this case, field1 is NULLable, then warn only if field2 is Nullable as well. If one of them is not NULLable, then no problem at all.
It would be very good if SQL Prompt can warn (like syntax error checking) if NULL is not handled for a NULLable column in join conditions or where clauses.
Note: Make sure to warn appropriately when ISNULL(field1, field2) is used. In this case, field1 is NULLable, then warn only if field2 is Nullable as well. If one of them is not NULLable, then no problem at all.