I want to constrain a SQL Server decimal column to only allow -1,0,1 as valid values.
Can you show me the SQL syntax for adding such a constraint. (I would like to know how to do it in both the CREATE TABLE statement and/or the ALTER TABLE ADD CONSTRAINT).
Or can this only be accomplished in a trigger?
or
Edit: thoughts...
You are probably looking for
CHECK Constraints