SQL constraint minvalue / maxvalue?

Question

Is there a way to set a SQL constraint for a numeric field that min value should be 1234 and max value should be 4523?

Answer 1

SQL Server syntax for the check constraint:

create table numbers (     number int not null         check(number >= 1234 and number <= 4523),     ... )  create table numbers (     number int not null,     check(number >= 1234 and number <= 4523),     ... )  create table numbers (     number int not null,     constraint number_range_check         check(number >= 1234 and number <= 4523),     ... ) 

Answer 2

CREATE TABLE WhatEver (     ...     NumericField INTEGER NOT NULL CHECK(NumericField BETWEEN 1234 AND 4523),     ... ); 

Note that 'BETWEEN AND' provides a range inclusive of the quoted limit values.