· 7 years ago · Feb 26, 2019, 10:26 AM
1IF NOT EXISTS (SELECT * FROM sys.databases WHERE name = '{FOO}')
2BEGIN
3 EXECUTE ('CREATE DATABASE {FOO}')
4 ALTER DATABASE {FOO} SET AUTO_CLOSE OFF
5END
6
7EXEC sp_executesql N'CREATE DATABASE {FOO};';
8EXEC sp_executesql N'ALTER DATABASE {FOO} SET AUTO_CLOSE OFF;';
9
10IF 1 = 1
11BEGIN
12 CREATE TABLE #t1(id INT);
13END
14ELSE
15BEGIN
16 CREATE TABLE #t1(x NVARCHAR(255));
17END