sql server new users: Create Database -- sql server new users

Re: Create Database

Andrew J. Kelly
5/25/2006 7:00:14 AM

sql server new users: DECLARE @DB VARCHAR(50), @SQL VARCHAR(100)
SET @DB = 'YourDBName'
SET @SQL = 'CREATE DATATABASE ' + @DB

EXEC ( @SQL)

http://www.sommarskog.se/dynamic_sql.html

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

Create Database

Taoge
5/25/2006 11:12:01 AM

Hi, all

When we need a new database , we use the following SQL statement:

Create Database database_name...

In this statement, we can not use a string variable as database_name.

Is there a way to use a string variable as database_name when we create
database?

Thanks