Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ndn_24_7
Starting Member
23 Posts |
 Posted - 2004-12-06 : 14:38:03
|
| Hello all,I'm trying to limit values in a column to 10,11,14,15,23,27,26,and 60 in the Check Constraints expression in SQL Server 2000. How do I do this? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-12-06 : 14:59:27
|
| ALTER TABLE myTable ADD CONSTRAINT CHK_Values CHECK (myColumn IN(10, 11, 14, 15, 23, 27, 26, 60))Change the table, constraint, and column names as needed. |
 |
|
|
ndn_24_7
Starting Member
23 Posts |
Posted - 2004-12-06 : 15:38:51
|
| it workedthank you very much |
|
|
|
|
|
|
|
|
Check Constraints Help