Using a defined variable to define the database?

[NSMan]

How can I do this?

declare @database varchar(20)
set @database='img000029'
select * from @database.dbo.imgs

 

[gmmastros]

You can use dynamic sql to do this. Dynamic SQL is best avoided if possible.

declare @database varchar(20)
Declare @SQL VarChar(8000)
set @database='img000029'

Set @SQL = 'select * from [' + @database + '].dbo.imgs'
Exec (@SQL)

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom