CODEWITHSUNDEEP
sql
Yehuda
Yehuda

Reputation: 3

How do I select a table column which has the name of a variable in SQL?

DECLARE @TESTFN VARCHAR(8) = 'TEST'

IF OBJECT_ID('tempdb..#fnl_rec') IS NOT NULL DROP Table #fnl_rec

SELECT code INTO #fnl_rec FROM TEST_src WHERE 1=2

-- I tried this but it doesn't work

INSERT INTO #fnl_rec
   SELECT **@TESTFN** FROM TEST_Fnl

Upvotes: 0

Views: 81

Answers (1)

cpalmer
cpalmer

Reputation: 311

You can use Dynamic SQL to use variables for column names. Try this:

DECLARE @sql_stmt varchar(1000)
SET @sql_stmt = 'INSERT INTO #fnl_rec
                SELECT ' + @TESTFN + ' FROM TEST_Fnl'
EXEC @sql_stmt

Upvotes: 1

Related Questions