Database objects as Stored Procedure parameters

Question

Why when we pass database objects as parameters in a stored database they are not accepted?

Ex:

@COLUNA nvarchar(30),
@VARIAVEL nvarchar(50)
SELECT * FROM TBL_TESTE WHERE @COLUNA = @VARIAVEL

The only alternative would be dynamic consultations?

Answer 1

SQL Server does not concatenate commands only values, so you can pass values for a command to be mounted and run, Example:

@COLUNA nvarchar(30),
 @VARIAVEL nvarchar(50)

declare @CMD varchar(4000)

set @CMD = 'SELECT * FROM TBL_TESTE WHERE '+@COLUNA+' = '+@VARIAVEL+''
 exec sp_executeSQL @CMD 

If you still have doubts let me know

Answer 2

declare
    @campo varchar(50),
    @valor varchar(50),
    @qry   varchar(max)

set @campo = 'Inscricao';
set @valor = '123456';
set @qry = 'select * from tabela where ' + @inscricao + ' = ' + @valor;

Exec (@qry)