<div>
<div class="content wysiwyg-content">
My question is fairly straight forward, im trying to Exec an SQL statement that will create a new database, however I want to retrieve the database path from a storedprocedure and use a variable. &nbsp;Along the lines of<br />
<br />
DECLARE @dbpath nvarchar(255)<br />
DECLARE @sql nvarchar(1000)<br />
<br />
EXEC spsqldatabasepath @dbpath<br />
<br />
Set @sql = 'CREATE DATABASE [dbname] ON (NAME = N'dbame.mdf', FILENAME = '+@dbpath , etc...<br />
EXEC(@sql)<br />
<br />
However the FILENAME clause is supposed to also have a text qualifer around it within the sql statement, how do I handle all the ' qualifiers ' and build the sql string?
</div>
</div>


My question is fairly straight forward, im trying to Exec an SQL statement that will create a new database, however I want to retrieve the database path from a storedprocedure and use a variable.  Along the lines of

DECLARE @dbpath nvarchar(255)
DECLARE @sql nvarchar(1000)

EXEC spsqldatabasepath @dbpath

Set @sql = 'CREATE DATABASE [dbname] ON (NAME = N'dbame.mdf', FILENAME = '+@dbpath , etc...
EXEC(@sql)

However the FILENAME clause is supposed to also have a text qualifer around it within the sql statement, how do I handle all the ' qualifiers ' and build the sql string?

Exec Create Database Statement with TSql Variable and Text Qualifiers

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.