sql server 中创建视图时使其条件生效.

CREATE VIEW DEPARTMENT_VIEW
AS
(SELECT DNAME,SCORE FROM DEPARTMENT_NEW
WHERE 0 < SCORE AND SCORE < 100)
WITH CHECK OPTION   --当插入的数据不满足条件时就会失败 ,警告不符合CHECK OPTION约束的条件

GO
SELECT * FROM DEPARTMENT_VIEW