What can be used to ensure that a field in a table only accepts a certain range of values?

Question

Hello
What can be used to ensure that a field in a table only accepts a certain range of values?
please reply me. i am waiting for your reply.
Thanx

Comments

I had a great time around the fire and the food was great too. glad I could contribute to your tips #9. <a href="http://www.discountu99boots.com/ugg-bailey-button-c-12">ugg bailey button</a>
<a href="http://www.discountu99boots.com/ugg-tall-metallic-c-7">ugg tall metallic</a>
<a href="http://www.discountu99boots.com/ugg-knightsbridge-c-19">ugg knightsbridge</a>
<a href="http://www.discountu99boots.com/ugg-rainier-c-22">ugg rainier</a>
<a href="http://www.discountu99boots.com/ugg-mayfaire-c-20">ugg mayfaire</a>  . your the best. see you next time

Answer 1

ood" one. The answer you want to hear is a Check constraint, which is defined on a database table that limits the values entered into that column. These constraints are relatively easy to create, and they are the recommended type for enforcing domain integrity in SQL Server.
Triggers can also be used to restrict the values accepted in a field in a database table, but this solution requires the trigger to be defined on the table, which can hinder performance in certain situations. For this reason, Microsoft recommends Check constraints over all other methods for restricting domain integrity