示例数据库 AdventureWorks安装脚本

/*============================================================================ File: instawdb.sql Summary: Creates the AdventureWorksDW sample database. Run this on any version of SQL Server (2008R2 or later) to get AdventureWorksDW for your current version. Date: October 26, 2017 Updated: October 26, 2017 ------------------------------------------------------------------------------ This file is part of the Microsoft SQL Server Code Samples. Copyright (C) Microsoft Corporation. All rights reserved. This source code is intended only as a supplement to Microsoft Development Tools and/or on-line documentation. See these other materials for detailed information regarding Microsoft code samples. All data in this database is ficticious. THIS CODE AND INFORMATION ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR PURPOSE. ============================================================================*/ /* * HOW TO RUN THIS SCRIPT: * * 1. Enable full-text search on your SQL Server instance. * * 2. Open the script inside SQL Server Management Studio and enable SQLCMD mode. * This option is in the Query menu. * * 3. Copy this script and the install files to C:\Samples\AdventureWorksDW, or * set the following environment variable to your own data path. */ :setvar SqlSamplesSourceDataPath "C:\Samples\AdventureWorksDW\" /* * 4. Append the SQL Server version number to database name if you want to * differentiate it from other installs of AdventureWorksDW */ :setvar DatabaseName "AdventureWorksDW" /* Execute the script */ IF '$(SqlSamplesSourceDataPath)' IS NULL OR '$(SqlSamplesSourceDataPath)' = '' BEGIN RAISERROR(N'The variable SqlSamplesSourceDataPath must be defined.', 16, 127) WITH NOWAIT RETURN END; SET NOCOUNT OFF; GO PRINT CONVERT(varchar(1000), @@VERSION); GO PRINT ''; PRINT 'Started - ' + CONVERT(varchar, GETDATE(), 121); GO USE [master]; GO -- **************************************** -- Drop Database -- **************************************** PRINT ''; PRINT '*** Dropping Database'; GO IF EXISTS (SELECT [name] FROM [master].[sys].[databases] WHERE [name] = N'$(DatabaseName)') DROP DATABASE $(DatabaseName); -- If the database has any other open connections close the network connection. IF @@ERROR = 3702 RAISERROR('$(DatabaseName) database cannot be dropped because there are still other open connections', 127, 127) WITH NOWAIT, LOG; GO -- **************************************** -- Create Database -- **************************************** PRINT ''; PRINT '*** Creating Database'; GO CREATE DATABASE $(DatabaseName); GO PRINT ''; PRINT '*** Checking for $(DatabaseName) Database'; /* CHECK FOR DATABASE IF IT DOESN'T EXISTS, DO NOT RUN THE REST OF THE SCRIPT */ IF NOT EXISTS (SELECT TOP 1 1 FROM sys.databases WHERE name = N'$(DatabaseName)') BEGIN PRINT '*******************************************************************************************************************************************************************' +char(10)+'********$(DatabaseName) Database does not exist. Make sure that the script is being run in SQLCMD mode and that the variables have been correctly set.*********' +char(10)+'*******************************************************************************************************************************************************************'; SET NOEXEC ON; END GO ALTER DATABASE $(DatabaseName) SET RECOVERY SIMPLE, ANSI_NULLS ON, ANSI_PADDING ON, ANSI_WARNINGS ON, ARITHABORT ON, CONCAT_NULL_YIELDS_NULL ON, QUOTED_IDENTIFIER ON, NUMERIC_ROUNDABORT OFF, PAGE_VERIFY CHECKSUM, ALLOW_SNAPSHOT_ISOLATION OFF; GO USE $(Datab�