Using a Database Name as a Variable

Question

I'm using this method (How to use a variable for the database name in T-SQL?) to pass a DBname into a variable. This variable is then used with something like this (simplified):

Select column From @DBname

However, when executed...You get, Command(s) completed successfully

Is there a way to adapt this method so that you can see the results of a query? (Not just create or alter a DB)

score 0 · Accepted Answer · answered Nov 08 '11 at 17:26

0

Something like this should work for you.

[[put code here that sets up @DBname]]
DECLARE @stmt NVARCHAR(MAX) = 'SELECT column FROM ' + @DBname;
EXEC sp_ExecuteSQL @stmt;

Edit: Note that I'm assuming you're using SQL server (you didn't specify in the question).

answered Nov 08 '11 at 17:26

ean5533

This works. I'm new to SQL - Didn't know about sp_ExecuteSQL. Thank you!! – Zee Nov 08 '11 at 18:44
No problem. Please mark the answer as accepted so that people can easily see the solution. Thanks. – ean5533 Nov 08 '11 at 18:49

1 Answers1