var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ? on Check Constraint expressions
I am creating a check constraint on a field (GRID_NBR) for values between 1 & 99. I am a little confused on creating the expression for it (Books online is vague).
Can I use the following expression: GRID_NBR BETWEEN 1 AND 99
Or do I have to use: GRID_NBR > 0 AND GRID_NBR < 100
I found my own answer (in Books Online)....here's the example it gave on the Constraint page...
Originally Posted by mrallgood
CREATE TABLE cust_sample
cust_id int PRIMARY KEY,
CONSTRAINT chk_id CHECK (cust_id BETWEEN 0 and 10000 )