UC知道在SQL SEVER 2000中如何使用check约束
来源：百度知道 编辑：UC知道 时间：2024/06/04 11:31:13
CREATE TABLE 学生
( Sname char(20) not null,
Sno int PRIMARY KEY,
Ssex char(2) DEFAULT '男'CHECK(性别 IN('男','女')),
Sdept varchar(20),
)
( Sname char(20) not null,
Sno int PRIMARY KEY,
Ssex char(2) DEFAULT '男'CHECK(性别 IN('男','女')),
Sdept varchar(20),
)
具体什么问题？
CREATE TABLE TStudent
( Sname char(20) not null,
Sno int PRIMARY KEY,
Ssex char(2) DEFAULT '男' CHECK(Ssex IN('男','女')) null,
Sdept varchar(20),
)
INSERT INTO TStudent(Sname,Sno,Ssex,Sdept)
SELECT '张三',1,'男','XXXX'
INSERT INTO TStudent(Sname,Sno,Sdept)
SELECT '李四',2,'XXXX'
INSERT INTO TStudent(Sname,Sno,Ssex,Sdept)
SELECT '王五',3,'水','XXXX'
SELECT * FROM TStudent