For that, open a new query window in SSMS for the database that you would like to fill with the sample. Important: Before you run the script in SSMS, you need to activate SQLCMD Mode. Create all tables and fill them with the data from the blob storage. PRINT 'Ended - ' + CONVERT(varchar, GETDATE(), 121) ī. Continue with next script (instadw_dw.sql) ' PRINT '*** Database $(DatabaseName) has succesfully been created. Make sure that the script is being run in SQLCMD mode and that the variables have been correctly set.*********' IF NOT EXISTS (SELECT TOP 1 1 FROM sys.databases WHERE name = N'$(DatabaseName)') * CHECK FOR DATABASE IF IT DOESN'T EXISTS, DO NOT RUN THE REST OF THE SCRIPT */ PRINT '*** Checking for Database $(DatabaseName)' PRINT '*** Creating Database $(DatabaseName)' RAISERROR('$(DatabaseName) database cannot be dropped because there are still other open connections', 127, 127) WITH NOWAIT, LOG If the database has any other open connections close the network connection. PRINT '*** Dropping Database $(DatabaseName) if exists' PRINT 'Started - ' + CONVERT(varchar, GETDATE(), 121) RAISERROR(N'The variable DatabaseName must be defined.', 16, 127) WITH NOWAIT
IF '$(DatabaseName)' IS NULL OR '$(DatabaseName)' = '' Open the script inside SQL Server Management Studio (SSMS) in the master database
THIS CODE AND INFORMATION ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHERĮXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY See these other materials for detailed information regarding This source code is intended only as a supplement to Microsoft Development Tools and/or
This file is part of the Microsoft SQL Server Code Samples.Ĭopyright (C) Microsoft Corporation. Summary: Creates the AdventureWorksDW sample database.
0 kommentar(er)
