7-13.sql

asp开发 asp开发 asp开发 asp开发

CREATE TABLE testCheck
(
	stu_id 		int IDENTITY(100000,1) PRIMARY KEY,
	Firstname 		VARCHAR(10) NOT NULL,
	lastname 		VARCHAR(10) NOT NULL,
	age 			int CHECK (age > 6),
	sex 			VARCHAR(30)  CHECK(sex in('M','F'))
)
INSERT INTO testCheck VALUES('xiao','zhou',5,'M')
INSERT INTO testCheck VALUES('xiao','zhou',7,'A')