Stored Procedure - variable DB-Name!

[CW1]

Hello
I have an Stored - Procedure with many Select's.
It is possible in an SELECT - statement the DB-Name variable to define?
e.g.
DELCARE @DB_Name nvarchar (50)
SET @DB_Name = 'TEST'
if exists (select * from @DB_Name.dbo.table) .....
Thank's [sig][/sig]

 

[ColinM]

You could so something like this:

DELCARE @DB_Name nvarchar (50), @SQL nvarchar(500)
SET @DB_Name = 'TEST'
set @SQL = 'if exists (select * from ' + @DB_Name + '.dbo.table)'
exec(@SQL)

[sig][/sig]