Depending on your needs, SQL Server allows you to use a single CHECK constraint across multiple columns or numerous CHECK Constraints across a single column.
Tag: Multiple CHECK Constraints on a single column in SQL Server
Column CHECK constraint for column ‘col1’ references another column, table ‘table1’.
Despite the fact that SQL Server permits the addition of multiple check constraints on a single column that is referenced by other columns in the
Big Data & SQL 