CODEWITHSUNDEEP
sqlsql-server-2008
HMcompfreak
HMcompfreak

Reputation: 171

parameter as column name in where clause

Is it possible to get values by keeping parameter in where clause like below :

DECLARE  @COLUMNNAME VARCHAR(50)
-- setting required column name 
SET @COLUMNNAME = (select name from sys.columns where OBJECT_ID = 
    (SELECT OBJECT_ID FROM SYS.objects WHERE name = 'BORVALIDATION') AND column_id = 2) 
--PRINT @COLUMNNAME (we do get the column name)
SELECT * FROM BORVALIDATION WHERE @COLUMNNAME = 'BBNAME'

Your knowledge and help is highly appreciated.

Upvotes: 0

Views: 2364

Answers (1)

rs.
rs.

Reputation: 27427

You can use dynamic SQL:

Declare @SQL VARCHAR(4000)
SET @SQL = 'SELECT * FROM BORVALIDATION WHERE ' + @COLUMNNAME + '= ''BBNAME''';
EXEC(@SQL);

Upvotes: 3

Related Questions