How to select dynamic database name with prefix along with
Hi team,
How to select dynamic database name along with table name in sql server.
E.g.
I have one server there are multiple database with prefix elcm_
Elcm_mags
Elcm _qadb Tec
And table is common in all database
Table name: tna.master
Select *from elcm_orgnizationname.tna.master
Now I want only change orgnizationname dynamically.
E.g
Select * from elcm_qadb.tna.master
Select *from elcm_mags.tna.master.
Pls give me solutions ASAP.
THAnks & regards,
Krunal Pande