select dynamic database

Question

hi team how to select dynamic database. e.g select top 10 * from ELCM_mahsqa.tna.rostering my query is that how to change 'mahsqa' dynamically suppose client name is abc then i want o/p like select top 10 * from ELCM_abc.tna.rostering

Ankur Mistry · Answer

Hello Please check the link might be useful. https://stackoverflow.com/questions/2073544/set-database-name-dynamically-in-sql-server-stored-procedure https://www.sqlservercentral.com/Forums/Topic972861-338-1.aspx

Midhun T P · Answer

Hi Please try dynamic queries - DECLARE @dbname VARCHAR(100) SET @dbname='abc' EXEC('SELECT top 10 * FROM ELCM_'+@dbname+'.tna.rostering')