(1) 创建grade规则,要求grade在0-100之间,并将该规则绑定在sc表的grade
列,解除该绑定。
create rule grade_rule as @grade>=0 and @grade<=100
go
exec sp_bindrule ‘grade_rule’,‘sc.grade’
go
exec sp_unbindrule ‘sc.grade’
go
(2) 创建sex规则,要求性别只取“男”或“女”,并将该规则绑定在student表的ssex列,解除该绑定。
create
rule sex_rule as @sex in (‘男’,‘女’)
go
exec
sp_bindrule ‘sex_rule’,‘student.ssex’
go
exec
sp_unbindrule ‘student.ssex’
go
(3) 创建高考分数默认值规则,默认值为600,并将该规则绑定在student表的gkfs列,解除该绑定,删除该规则。
create default gkfs_fault as 600
go
exec sp_bindefault ‘gkfs_fault’,‘student.gkfs’
go
exec sp_unbindefault ‘student.gkfs’
go
(4) 创建数据库studentManagement,