你管理着位于你们公司总部SQLServer2008数据库。数据库中有一张表dbo.Sales。你需要为dbo.Sales表创建不同的视图来让每一个部门插入、更新、删除行,每个部门必须仅仅能够插入、更新、删除与他们部门有关的行。你应该为部门Region1创建什么视图?
A、CREATEVIEWdbo.Region1SalesASSELECTSalesID,OrderQty,SalespersonID,RegionIDFROMdbo.SalesWHERERegionID=1
B、CREATEVIEWdbo.Region1SalesASSELECTSalesID,OrderQty,SalespersonID,RegionIDFROMdbo.SalesWHERERegionID=1WITHCHECKOPTION
C、CREATEVIEWdbo.Region1SalesWITHSCHEMABINDINGASSELECTSalesID,OrderQty,SalespersonID,RegionIDFROMdbo.SalesWHERERegionID=1
D、CREATEVIEWdbo.Region1SalesWITHVIEW_METADATAASSELECTSalesID,OrderQty,SalespersonID,RegionIDFROMdbo.SalesWHERERegionID=1