34,838
社区成员




-- declare database name
DECLARE @dbName varchar(20);
SET @dbName='b2018';
IF EXISTS (select * From master.dbo.sysdatabases WHERE name=@dbName)
PRINT @dbName + ' DATABSE exist';
ELSE
BEGIN
CREATE DATABASE [@dbName] ON PRIMARY
( NAME = @dbName
...
END
-- declare database name
DECLARE @dbName varchar(20);
SET @dbName='b2018';
IF EXISTS (select * From master.dbo.sysdatabases WHERE name=@dbName)
PRINT @dbName + ' DATABSE exist';
ELSE
BEGIN
DECLARE @sql NVARCHAR(max)=' CREATE DATABASE '+@dbName+' ON PRIMARY( NAME = '+@dbName+'...'
EXEC(@sql)
END
-- declare database name
DECLARE @dbName varchar(20),@sql NVARCHAR(MAX)
SET @dbName='b2018';
IF EXISTS (select * From master.dbo.sysdatabases WHERE name=@dbName)
PRINT @dbName + ' DATABSE exist';
ELSE
BEGIN
SET @sql='CREATE DATABASE ['+@dbName+'] ON PRIMARY
( NAME = @dbName
...'
PRINT @sql
EXEC(@sql)
END