实现以上的数据库字段属性设置,其中数据库脚本如下:【值得琢磨学习】
use UserInformation create table StudentInfo( ID nvarchar(10) not null primary key, Name nvarchar(20) not null, Sex nchar(1) not null check (Sex in ('男','女')) constraint DF_Student_Information_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, )