dynamische variable

[arcon]

lösung:


declare @variable as nvarchar(255)
set @variable = '1'
declare @Parameter as nvarchar(255)
set @Parameter = 'Parameter '
declare @Description as nvarchar (255)
set @Description = ' Description'
declare @Param as nvarchar(255)
set @Param = @Parameter + @Variable + @Description


select param, Value
from param_settings
where param = @param