How can I choose the db according to procedure parameter?

[efratk]

I would like to write a stored procedure that gets database name as parameter and use this parameter inside the procedure:
i.e. SELECT a from param_db.table1
It seems that I can't use a parameter instead of the db name. Is there a work around?

[sicarie]

Hmm, that's probably going to depend on what database you are using (MySQL, PostGRESQL, MSSQL, Oracle, etc...), and you should ask it in the appropriate forum.

[SatSunDev]

I am also looking for something like that. Do you happen to find a solution for your problem? I am working in MSSQL 2005.

I would like to write a stored procedure that gets database name as parameter and use this parameter inside the procedure:
i.e. SELECT a from param_db.table1
It seems that I can't use a parameter instead of the db name. Is there a work around?