#add column dynamically

Post has been published on http://www.varindersandhu.in/2012/12/04/sql-server-how-to-add-column-dynamically-in-where-clause/

SQL Server - How to add column dynamically in where clause

In this post, we will learn with example how to add the column dynamically in where clause.

Example:

For demo we have table as shown in the snapshot

add column dynamically in where clause

Basically we want to execute following script (i.e. Script: 1) but column name (i.e. FIRST_NAME) added dynamically in where clause.

<!-- google_ad_client = "pub-2404605494811633"; google_alternate_color = "FFFFFF"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_link = "0000FF"; google_color_bg = "FFFFFF"; google_color_text = "000000"; google_color_url = "008000"; google_ui_features = "rc:6"; //-->

Script: 1

SELECT * FROM EMPLOYEE WHERE FIRST_NAME = 'VARINDER'

Created a table and insert the column name value (i.e. FIRST_NAME) as shown in the snapshot

add column dynamically in where clause

Now we will execute the Script: 1 in which we add the column dynamically in where clause

DECLARE @COL VARCHAR(15) DECLARE @SQL VARCHAR(1000) SELECT @COL = column1 from TEMP_Table SET @SQL = ' SELECT * from EMPLOYEE WHERE ' + @Col + ' = ' + '''VARINDER''' EXEC(@SQL)