use variable as a column name in sql

Question

Is there any to use variable names as a column name in sql join, without using dynamic query?

I want to use it like below.

DECLARE @PT_CONST VARCHAR(MAX)

SELECT * FROM TBL T WHERE T.@PT_CONST='VAL'

you can do like this if you can SELECT * FROM TBL T WHERE coulmn_nmae = @PT_CONST — Hardik Parmar
– Hardik Parmar, Commented Nov 12, 2014 at 8:19

Arvo · Accepted Answer · 2014-11-12 08:21:25Z

1

Directly not. If you know that your column name can be one of the predefined set, then you could use something like

... WHERE CASE @PT_CONST WHEN 'Col1' THEN Col1 WHEN 'Col2' THEN Col2 ... END = 'VAL'

answered Nov 12, 2014 at 8:21

Arvo

10.6k1 gold badge34 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

RobertKing Over a year ago

dont know the column names..so your solution is not feasible

Arvo Over a year ago

Then you have no solution without dynamic SQL. SQL server query processor needs to know column names at compile time, there is no way around it. You could check presence of columns before building your dynamic SQL to avoid errors of course.

Collectives™ on Stack Overflow

use variable as a column name in sql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related