Switch Database Connection

Question

Hello I have one query. I have one Master database in which i have the company id password and the name of the connection string for other database. For Eg: Master Database: CompanyID Password ConnStr ABC0001 ****** MyNewConn1 ABC0002 ****** MyNewConn2 My question is can i switch from one database to another database taking the connection string from the master database and using that connection string for connecting to other database under same server? Please Help Me....

Manikavelu Velayutham · Answer

If your credential has the permission to all database you can do a cross database query in a single connection string select * from database1..table1 select * from database2..table1 you can query cross database also like select * from database1..table1 d1 join database2..table1 dt on d1.id = d2.id