<div>
You need to put the full select command into a variable and the execute it:<br />

<pre><code id="code-20-40760438-1">declare @MySelect as varchar (MAX)
declare @dbname as varchar (50)
 set @dbname = 'TESTDB'

set @MySelect = 'IF NOT EXISTS (SELECT name FROM ['+@dbname+'].sys.indexes WHERE name = '''TECH_IX_DOMAINID_GROUPID_RECORDTYPE''')'

EXECUTE(@MySelect)</code></pre>
</div>


You need to put the full select command into a variable and the execute it:


declare @MySelect as varchar (MAX)
declare @dbname as varchar (50)
 set @dbname = 'TESTDB'

set @MySelect = 'IF NOT EXISTS (SELECT name FROM ['+@dbname+'].sys.indexes WHERE name = '''TECH_IX_DOMAINID_GROUPID_RECORDTYPE''')'

EXECUTE(@MySelect)

<div>
Thanks Incorrect syntax near 'TECH_IX_DOMAINID_GROUPID_<wbr />RECORDTYPE<wbr />'.
</div>


Thanks Incorrect syntax near 'TECH_IX_DOMAINID_GROUPID_RECORDTYPE'.

<div>
So, all the points going to another Expert just because an extra quote?
</div>


So, all the points going to another Expert just because an extra quote?

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I try to use variable @dbname in a script, the following error is returned :Incorrect syntax near ')'.<br />
<br />
declare @dbname as varchar (50)<br />
set @dbname = 'TESTDB'<br />
<br />
IF NOT EXISTS (SELECT name FROM ['+@dbname+'].sys.indexes WHERE name = 'TECH_IX_DOMAINID_GROUPID_<wbr />RECORDTYPE<wbr />')<br />
<br />
Thanks<br />
<br />
Regards
</div>
</div>


Hello,

I try to use variable @dbname in a script, the following error is returned :Incorrect syntax near ')'.

declare @dbname as varchar (50)
set @dbname = 'TESTDB'

IF NOT EXISTS (SELECT name FROM ['+@dbname+'].sys.indexes WHERE name = 'TECH_IX_DOMAINID_GROUPID_RECORDTYPE')

Thanks

Regards

use variable @dbname in a stored procedure

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.