create table person
(
id int not null primary key identity,
stuname char(8) not null ,
sex char not null default('') ,
age int not null,
stuno varchar(20) not null
)
ALTER TABLE [person]  WITH CHECK ADD  CONSTRAINT [CK_person] CHECK  (([sex]='1' OR [sex]='0'))
或
ALTER TABLE [person1]  WITH CHECK ADD  CONSTRAINT [CK_person1] CHECK  (([sex]='男' OR [sex]='女'))
GO
 

GO
---改成添加约束

------解决方案--------------------
SQL code

create database stu
go

create table person
(
id int not null primary key identity,
stuname char(8) not null ,
sex char not null constraint ck_sex check(sex in('1','0')),
age int not null,
stuno varchar(20) not null
)

create table person1
(
pid int not null identity primary key ,
pno varchar(20) not null,
psex char not null constraint ck_psex check(psex in('男','女')),
age int not null
)

------解决方案--------------------

第二个表应用的外键也有问题
SQL code

create table person
(
id int not null  identity,
stuname char(8) not null ,
sex char not null default('1')  CONSTRAINT [CK_person] CHECK  (([sex]='1' OR [sex]='0')) ,
age int not null,
stuno varchar(20) not null primary key
)

create table person1
(
pid int not null primary key identity,
pno varchar(20) not null foreign key (pno) references person(stuno),
psex Nchar(2) not null default ('男') CONSTRAINT [CK_person1] CHECK  (([psex]='男' OR [psex]='女')),
age int not null
)

GO