Pass database and table as parameters to process

Question

I need to make a Stored Procedure of the following kind:

USE master
GO

CREATE PROCEDURE dbo.sp_DR @bd NVARCHAR(20), @VAL AS INT
AS

SELECT * INTO #TEMP FROM @bd where campo =@val 

SELECT campo1, campo2 from #temp
Em que @bd seria a base de dados e a tabela que iria utilizar.

How to pass this indication to the Stored Procedure?

If you put the BD table manually the SP is working as intended.

Answer 1

You can create a dynamic query with the parameters and run with EXEC(), so for example:

CREATE PROCEDURE dbo.sp_DR @bd NVARCHAR(20), @VAL AS INT
AS

DECLARE @COMANDO nvarchar(1000)    
SET @COMANDO = 'SELECT * INTO #TEMP FROM ' +  @bd + where campo = ' + STR(@val)
EXEC (@COMANDO)

SELECT campo1, campo2 from #temp

So you can mount the whole query dynamically and then run. Note that as the @val parameter is INT need to convert, because all @COMMAND content is nvarchar