Pass column name as variable to where condition in dynamic select query in SQL Server

Hi stellusmca,

Without using dynamic query its not possible. You have to write the query dynamically like in the below sample query.

SQL

DECLARE @Search1 NVARCHAR(200)                                 
DECLARE @Search2 NVARCHAR(200)
SET @Search1 = 'AAFKM'
SET @Search2 = 'CustomerID'
DECLARE @sqlQuery NVARCHAR(MAX); 
SET @sqlQuery = N'SELECT TOP 10 CustomerID,ContactName FROM Customers WHERE ' + @Search2 + ' = ''' + @Search1 + ''''
EXEC (@sqlQuery)

Output