How to pass a database name as a parameter in SQL Server

Question

USE master
GO

DECLARE @DbName nvarchar(MAX)
SET @DbName = N'DataBase'

ALTER DATABASE @DbName
SET SINGLE_USER WITH ROLLBACK IMMEDIATE

ALTER DATABASE @DbName SET OFFLINE WITH NO_WAIT
GO

ALTER DATABASE @DbName SET ONLINE
GO

ALTER DATABASE @DbName
SET MULTI_USER
GO

I know i can use EXEC but it's a bit ugly....

Answer 1

It is impossible to use DB name from variable.

Use Dynamic Querying, even if it is ugly.

Answer 2

You can't use the database name in a variable.

You have several options:

• Different DML scripts for each DB
• Dynamic SQL