Skip to content

Instantly share code, notes, and snippets.

@johlju

johlju/Get-SQLScript.sql

Last active January 5, 2018 15:15
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save johlju/a452c145a0f13b4c60cff4ef47b7e22e to your computer and use it in GitHub Desktop.
Save johlju/a452c145a0f13b4c60cff4ef47b7e22e to your computer and use it in GitHub Desktop.
Download ZIP
Example using SqlScript
Raw
Get-SQLScript.sql
SELECT name FROM sys.databases WHERE name = 'MyScriptDatabase1'
Raw
Set-SQLScript.sql
CREATE DATABASE [MyScriptDatabase1]
Raw
Test-SQLScript.sql
if (select count(name) from sys.databases where name = 'MyScriptDatabase1') = 0
BEGIN
RAISERROR ('Did not find database [MyScriptDatabase1]', 16, 1)
END
ELSE
BEGIN
PRINT 'Found database [MyScriptDatabase1]'
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment