创建索引视图的sql语句模板代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】创建索引视图的sql语句模板

作者:Dezai.CN / 发布于2012/2/10/ 1004

<div>
<div>
创建索引视图的sql语句模板：</div>
<div>-- =============================================
-- Create Indexed View template
-- =============================================
USE <database_name, sysname, AdventureWorks >
GO
SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON
SET NUMERIC_ROUNDABORT OFF</div>
<div>IF object_id(N'<schema_name, sysname, dbo >.<view_name, sysname, SalesByOrderDate >', 'V') IS NOT NULL
DROP VIEW <schema_name, sysname, dbo >.<view_name, sysname, SalesByOrderDate >
GO</div>
<div>CREATE VIEW <schema_name, sysname, dbo >.<view_name, sysname, SalesByOrderDate > 
WITH SCHEMABINDING AS
<select_statement, , SELECT OrderDate, count_big(*) C, SUM(TotalDue) DateTotal FROM Sales.SalesOrderHeader GROUP BY OrderDate ></div>
<div>GO
CREATE UNIQUE CLUSTERED INDEX <view_name, sysname, SalesByOrderDate >_IndexedView
ON <schema_name, sysname, dbo >.<view_name, sysname, SalesByOrderDate >(<index_key_columns, , OrderDate >)</div>
<div>
创建普通视图的sql语句模板：</div>
<div>-- =============================================
-- Create View template
-- =============================================
USE <database_name, sysname, AdventureWorks >
GO</div>
<div>IF object_id(N'<schema_name, sysname, dbo >.<view_name, sysname, Top10Sales >', 'V') IS NOT NULL
DROP VIEW <schema_name, sysname, dbo >.<view_name, sysname, Top10Sales >
GO</div>
<div>CREATE VIEW <schema_name, sysname, dbo >.<view_name, sysname, Top10Sales > AS
<select_statement, , SELECT TOP 10 * FROM Sales.SalesOrderHeader ORDER BY TotalDue DESC ></div>
<div>
删除视图的sql语句模板：</div>
<div>-- =============================================
-- Drop View template
-- =============================================
DROP VIEW <schema_name, sysname, dbo >.<view_name, sysname, Top10Sales ></div>
<div>本文来源于:http://www.lmwlove.com/ac/ID745
</div>
</div>

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)