UC知道SQL约束语句有问题，请高手帮忙
来源：百度知道 编辑：UC知道 时间：2024/06/04 15:30:13
use IT_Training_Center
create table Student_Information(
ID nvarchar(10) not null primary key,
Name nvarchar(20) not null,
Sex nchar(1) not null check (Sex in ('男','女')) constraint Sex default '男',
Birthday smalldatetime not null check (Birthday >= '1920-01-01') constraint Birthday default '1980-01-01',
Education nchar(2) not null check (Education in('小学','初中','高中','专科','本科','大学','硕士','博士','其它'))constraint Education default '小学',
EntryTime smalldatetime not null check (EntryTime >= '2009-01-01') constraint EntryTime default '2009-01-01',
Address nvarchar(50) not null,
Phone nvarchar(20) null,
Class nchar(4) not null,
)
use IT_Training_Center
create table Employee_Information(
ID nvarchar(10) not null primary key,
Name nvarchar(20) not null,
Sex nchar(1) not null check
create table Student_Information(
ID nvarchar(10) not null primary key,
Name nvarchar(20) not null,
Sex nchar(1) not null check (Sex in ('男','女')) constraint Sex default '男',
Birthday smalldatetime not null check (Birthday >= '1920-01-01') constraint Birthday default '1980-01-01',
Education nchar(2) not null check (Education in('小学','初中','高中','专科','本科','大学','硕士','博士','其它'))constraint Education default '小学',
EntryTime smalldatetime not null check (EntryTime >= '2009-01-01') constraint EntryTime default '2009-01-01',
Address nvarchar(50) not null,
Phone nvarchar(20) null,
Class nchar(4) not null,
)
use IT_Training_Center
create table Employee_Information(
ID nvarchar(10) not null primary key,
Name nvarchar(20) not null,
Sex nchar(1) not null check
因为你两个表中SEX字段的约束都使用了相同的名称
第一个表的Sex字段定义做如下修改：
Sex nchar(1) not null check (Sex in ('男','女')) constraint DF_Student_Information_Sex default '男',
第二个表的Sex字段定义做如下修改：
Sex nchar(1) not null check (Sex in ('男','女')) constraint DF_Employee_Information_Sex default '男',
给点分再告诉你