exec 'sample_db'
alter procedure sp_sample_db @db_name nvarchar(100) AS BEGIN SET NOCOUNT ON; if exists(select name from master.dbo.sysdatabases where name =@db_name) begin select * from @db_name.dbo.my_table end else begin print 'db not exists' end END GO
select * from [sample_db].dbo.my_table
Declare @db_name varchar(20)='testTB' select name from master.dbo.sysdatabases where name=@db_name declare @q varchar(1000) set @q = 'SELECT * FROM ' + @db_name + '.dbo.my_table' exec (@q)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)