CREATE TABLE dbo.ViewPractice(Id int PRIMARY KEY,Price decimal(8,2) NOT NULL);INSERT dbo.ViewPractice(Id,Price) VALUES(1,20);GOCREATE VIEW dbo.V_PricePracticeASSELECT Id,Price FROM dbo.ViewPractice WHERE Price>=10WITH CHECK OPTION; -- 经此视图改数据后,记录仍须符合视图的筛选条件GO-- 把视图中1号价格改到25,实际上修改的是ViewPracticeUPDATE dbo.V_PricePractice SET Price=25 WHERE Id=1;SELECT * FROM dbo.ViewPractice; -- 25-- 简单视图也可插入和删除:操作仍落到同一张基础表INSERT dbo.V_PricePractice(Id,Price) VALUES(2,15);SELECT * FROM dbo.ViewPractice; -- 基础表现在有编号1和2DELETE FROM dbo.V_PricePractice WHERE Id=2;SELECT * FROM dbo.ViewPractice; -- 删除后只剩编号1-- 下面是假设操作,不执行;改成5会违反WITH CHECK OPTION-- UPDATE dbo.V_PricePractice SET Price=5 WHERE Id=1;DROP VIEW dbo.V_PricePractice;DROP TABLE dbo.ViewPractice; -- 只清理刚建立的演示对象