Column name not working when placed inside a variable in SQL Server

Asked Feb 18 '16 at 08:17

Active Feb 18 '16 at 08:36

Viewed 39 times

Can anyone please explain why this code is not working?

ALTER function sample1 (@col VARCHAR (32), @keyWord VARCHAR (32))
RETURNS INT
AS
BEGIN
    DECLARE @res INT

    SELECT @res = COUNT(*) 
    FROM m_table 
    WHERE @col LIKE 'John Leo'

    RETURN @res
END

I noticed that when I hardcoded the column name, it works. but if I use the variable @var for it, it returns a value of 0. Is it because I placed the column name in a variable?

edited Feb 18 '16 at 08:26

marc_s

704,970
168
1,303
1,425

asked Feb 18 '16 at 08:17

JanLeeYu

4

You have to use dynamic sql. – Felix Pamittan Feb 18 '16 at 08:19
2

You cannot parametrize table or column names – marc_s Feb 18 '16 at 08:26
Is there any possible way to make it work? – JanLeeYu Feb 18 '16 at 08:28

Column name not working when placed inside a variable in SQL Server

0 Answers0