SQL 脚本创建数据库时, 能用变量代替数据库名吗?

[ltolll]

-- 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

写到 NAME = @dbName 这里就报语法错误了.

[吉普赛的歌]

只能用动态SQL:

-- 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

[二月十六]

试试这样

-- 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

[ltolll]

另一个问题:https://bbs.csdn.net/topics/392501870