Question

sql2005定义视图用了with check option，为什么还能插入？？

create view cus_view2 as select customerid,companyname,address,city from customers
with check option
insert into cus_view2 values( 'Abc','Cfde','BJHH6','Vhghd23')
create view cus_view3 as select customerid,companyname,address,city from customers with check option ----t cus_view3 t customers
insert into cus_view2 values( 'Abcd','Cfde','BJHH6','Vhghd23') ----t cus_view2 t customers

----------------------------------

Answer 1

对于没有where 子句的视图，使用with check option是多余的。所以你要把语句改成：
create view cus_view2 as select customerid,companyname,address,city from customers where 1=1
with check option
试试