Hello. I am obviously very new to SQL Server 2005 Express. I am an Access developer and I am giving a try to SQL Server Express. Maybe my question will be answered faster this way 8)
I am going through a book (... In 24 Hours series) and every time I try to complete a simple exercise about creating a (seems like a) Check Constraint I get an error. Here's what I am doing:
The field is State: Char (2) and we want to apply the constraint where only the following values are accepted: CA, UT, AZ WY, and a few others.
I click the selected to the left of the State field and click Manage Check Constraints.
In the Check Constraint dialog I click Add and the constraint CK_Table_1* appears. The name is simply CK_Table_1.
I name the constraint ckState (like in the book)
In the Expression I type @State In('CA', 'UT', 'AZ', 'WY') and as soon as I hit Enter a message appears that there is an error in the constraint and ask me if I want to Edit it.
I am at loss here because this matches the screen shot in the book.
Can anyone help?
I hope I provided enough information.