Breaking News: Grepper is joining You.com. Read the official announcement!

how to pass dynamic column name in sql query

Muhammad Hassan answered on April 18, 2022 Popularity 8/10 Helpfulness 4/10

answer how to pass dynamic column name in sql query

related dynamic column name in sql

how to pass dynamic column name in sql query

Comment

DECLARE @sqlCommand varchar(1000)
DECLARE @columnList varchar(75)
DECLARE @city varchar(75)

SET @columnList = 'AddressID, AddressLine1, City'
SET @city = '''London'''
SET @sqlCommand = 'SELECT ' + @columnList + ' FROM Person.Address WHERE City = ' + @city

EXEC (@sqlCommand)

Popularity 8/10 Helpfulness 4/10 Language sql

Source: www.mssqltips.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Apr 18 2022

Muhammad Hassan

0 Answers Avg Quality 2/10

Closely Related Answers

dynamic column name in sql

Comment

note: this depend on your dbms if this code will work fine

to use dynamic column name in sql you can:

use variable:
SET @column_name = 'first_name';
SELECT @column_name FROM users;

use subquery:
SELECT column_name FROM columns WHERE column_id = 1;
SET @column_name = (SELECT column_name FROM columns WHERE column_id = 1);
SELECT @column_name FROM users;

use case statement:
SET @column_name = (CASE WHEN condition THEN 'column1' ELSE 'column2' END);
SELECT @column_name FROM users;

use prepared statements:
SET @sql = CONCAT('SELECT ', ?, ' FROM users');
PREPARE stmt FROM @sql;
EXECUTE stmt USING @column_name;

Popularity 8/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jan 15 2023

Blasian

0 Answers Avg Quality 2/10

how to pass dynamic column name in sql query

Contents

More Related Answers

how to pass dynamic column name in sql query

Closely Related Answers

dynamic column name in sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.