当前位置: 首页 >  江开  > 软件工程  > 详细

你管理位于公司总部的SQL Server 2008数据库。该数据库包含一个名为dbo.Sales的表。你需要创建dbo.Sales表的不同视图,这些视图将由每个地区插入、更新和删除行。每个地区办事处必须只能插入、更新和删除其相应地区的行。应该为Region1创建哪个视图?
A.CREATE VIEW dbo.Region1Sales AS SELECT
SalesID,OrderQty,SalespersonID,RegionID FROM dbo.Sales WHERE RegionID = 1;
B.CREATE VIEW dbo.Region1Sales AS SELECT SalesID,OrderQty,SalespersonID,RegionID
FROM dbo.Sales WHERE RegionID = 1 WITH CHECK OPTION;
C.CREATE VIEW dbo.Region1Sales WITH SCHEMABINDING AS SELECT
SalesID,OrderQty,SalespersonID,RegionID FROM dbo.Sales WHERE RegionID = 1;
D.CREATE VIEW dbo.Region1Sales WITH VIEW_METADATA AS
SELECT SalesID,OrderQty,SalespersonID,RegionID FROM dbo.Sales WHERE RegionID =

答案是:

B
出自  江开  >  软件工程

更多答案联系客服:19139051760
本题添加时间:2023/4/3 12:59:00