Hi Dmitry,

Use dynamic SQL, something like this:

use [FirstSQLDatabase];
go 
declare @cSecondDb as Varchar(100);
declare @sql as varchar(max);
set @cSecondDb = 'SecondSQLDatabase';
set @sql = 'select * from ' + @cSecondDb + '.dbo.mytable';
exec (@sql);

and replace dbo with the appropriate schema name if it's not dbo.


>Hi,
>
>I am testing the SQL Select with a name of the database not current.
>This case works:
>

>use [FirstSQLDatabase]
>go
>select * from SecondSQLDatabase..mytable where 1=1
>

>
>Now I want to put the 'SecondSQLDatabase' into a variable. Here is how I do it:
>

>use [FirstSQLDatabase]
>go 
>declare @cSecondDb as Varchar(100)
>set @cSecondDb = 'SecondSQLDatabase'
>select * from @cSecondDb..mytable where 1=1    -- this is the line that causes the syntax error.
>

>
>The above produces syntax error.
>
>What am I missing?
>TIA