题目：
单选题
你管理位于公司总部的SQL Server 2008数据库。该数据库包含一个名为dbo.Sales的表。你需要创建dbo.Sales表的不同视图，这些视图将由每个地区插入、更新和删除行。每个地区办事处必须只能插入、更新和删除其相应地区的行。应该为Region1创建哪个视图？( )
- ACREATE VIEW dbo.Region1Sales AS SELECT
SalesID,OrderQty,SalespersonID,RegionID FROM dbo.Sales WHERE RegionID = 1;
- BCREATE VIEW dbo.Region1Sales AS SELECT
SalesID,OrderQty,SalespersonID,RegionID FROM dbo.Sales WHERE RegionID = 1 WITH
CHECK OPTION;
- CCREATE VIEW dbo.Region1Sales WITH SCHEMABINDING AS
SELECT SalesID,OrderQty,SalespersonID,RegionID FROM dbo.Sales WHERE RegionID =
1;
- DCREATE VIEW dbo.Region1Sales WITH VIEW_METADATA AS SELECT
SalesID,OrderQty,SalespersonID,RegionID FROM dbo.Sales WHERE RegionID = 1;
答案：
<查看本题扣1积分>