SQL 2005 specific values to a column

• ssheves

  SSC-Addicted

  Points: 413

  More actions

  February 19, 2009 at 8:03 am

  #127851

  Hi,

  I'm creating a table and want one of the fields to be populated with specific values.

  For example I want Shai field value to be either '1234' or '5678' (all other values will raise an error)

  Does any of you know how to do it?

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  February 19, 2009 at 8:57 am

  #946811

  You could do this with a check contraint. Here's a reference from BOL...

  http://msdn.microsoft.com/en-us/library/ms179491(SQL.90).aspx

  Basically you'd just do an alter Table Statement like so...

  Alter Table myTable

  ADD CONSTRAINT CK_mytable_Shai --or whatever meaningful name you choose

  CHECK (Shai = '1234' OR Shai = '5678')

  -Luke.

  To help us help you read this[/url]For better help with performance problems please read this[/url]

• ssheves

  SSC-Addicted

  Points: 413

  More actions

  February 20, 2009 at 12:21 am

  #947333

  Thanks.

  Checked that and it works

  Shai