南京市网站建设_网站建设公司_定制开发_seo优化

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