SQL Server 2005 Create Table with Column Default value range

Posted by Matt on Stack Overflow See other posts from Stack Overflow or by Matt
Published on 2010-06-04T08:30:23Z Indexed on 2010/06/06 19:22 UTC
Read the original article Hit count: 239

Trying to finish up some homework and ran into a issue for creating tables. How do you declare a column default for a range of numbers. Its reads: "Column Building (default to 1 but can be 1-10)" I can't seem to find ...or know where to look for this information.

CREATE TABLE tblDepartment
(
Department_ID int NOT NULL IDENTITY,
Department_Name varchar(255) NOT NULL,
Division_Name varchar(255) NOT NULL,
City varchar(255) default 'spokane' NOT NULL,
Building int default 1 NOT NULL,
Phone varchar(255)
)

I tried Building int default 1 Between 1 AND 10 NOT NULL, that didn't work out I tried Building int default 1-10, the table was created but I don't think its correct.

© Stack Overflow or respective owner

Related posts about sql-server-2005

Related posts about homework