Rules and NULL Values

You cannot define a column to allow nulls, and then override this definition with a rule that prohibits null values.

For example, if a column definition specifies NULL and the rule specifies the following, an implicit or explicit NULL does not violate the rule:

@val in (1,2,3)

The column definition overrides the rule, even a rule that specifies:

@val is not null