looking for datatype

[atmoz]

I'm looking for a datatype what's the same is as Enum or set in mysql.
Only now I'm looking for it in MS SQL.
The description for Enum is: Columns of this type can only hold one of the values listed or NULL
the only difference between enum and set is that Enum has a maximum values of 65535 and Set a maximum values of 64.

 

[JamesLean]

There's no data type to control specific values for a column - you should use a CHECK CONSTRAINT for this. Look this up in BOL for more info. --James