SQL Server 视图与存储过程的构建及应用
1. 视图的构建与索引创建
1.1 视图代码修改与重建
在新的查询编辑器窗格中，我们可以对代码进行修改。为了能够重新创建视图，需要修改两个SET选项并添加一个DROP VIEW语句。以下是示例代码：
USE [ApressFinancial] GO /****** Object: View [CustomerDetails].[vw_CustFinProducts] Script Date: 08/07/2008 12:31:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO DROP VIEW CustomerDetails.vw_CustFinProducts GO CREATE VIEW [CustomerDetails].[vw_CustFinProducts] WITH SCHEMABINDING AS SELECT c.CustomerFirstName + ' ' + c.CustomerLastName AS CustomerName, c.AccountNumber, fp.ProductName, cp.AmountToCollect, cp.Frequency, cp.LastCollected FROM CustomerDetails.Customers c JOIN CustomerDetails.CustomerProducts cp ON cp.CustomerId = c.CustomerId JOIN
(1))
