Mapping Dynamic Column Names In Sql Server

DECLARE @step VARCHAR(25) = '15'; DECLARE @COL VARCHAR(50) = step_col_@step; UPDATE table_tblName SET @COL= WHERE I have the above query where

Solution 1:

Try the below query,

DECLARE@COLVARCHAR(50) ='step_col_'+@step

Solution 2:

Pass the variables like this to form a dynamic sql query

DECLARE@stepVARCHAR(25) ='15';
DECLARE@COLVARCHAR(50) ='step_col_'+@stepexec ('UPDATE table_tblName SET '+@COL+'=<some value> WHERE <condition>')

Solution 3:

DECLARE@stepVARCHAR(25) ='15';
 DECLARE@COLVARCHAR(50) ='step_col_'+@step;
 DECLARE@StringVARCHAR(500) =''SET@String='UPDATE table_tblName SET '''+@COL+''' = <some value> WHERE  
 <condition>'EXEC (@String)

Solution 4:

DECLARE@stepVARCHAR(25) ='15';
DECLARE@COLVARCHAR(50) 
SET@COL='step_col'+@step;

UPDATE table_tblName SET@COL=<somevalue>WHERE<condition>