title: How can I use check constraint in sql server 2005
body: <p>i want to check for a particular set of values.<br>
  eg</p>
  
  <ul>
  <li>check columnname should be between 1 to 5</li>
  <li>check columnname should be either 1 or 2 or 4</li>
  </ul>