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
