NOT IN and NULL ( a dangerous combination)

Since NULL represents an unknown value, looking for values in the outer table that are not unknown (i.e. employees’ ids that are not in a list that contains NULL values) would return 0 rows.

ALTER USER DEFINED DATATYPE

We cannot alter the User-defined types after creation.

PROCEDURE