Using literal values in Stored Procedure

[MattDavies51]

Hi, I'm hoping that somebody can help me here.

Basically, I'm passing the parameter @db_desc into a stored procedure. @db_desc is the name of a SQL Server database residing on the same SQL Server.

I want to use this parameter to identify the database in a select statement, like so:

select * from @db_desc..<table_name> where <expression>

Any ideas?
Regards
Matt

 

[swampBoogie]

dynamic sql

create procedure sb_3(@db_desc varchar(128))
as
declare @s varchar(300)
set @s = 'select * from ' + @db_desc + '..<table_name> where <expression>'
exec(@s)