I have a stored procedure that uses containstable and want to make it a little dynamic so I was going to add a parameter that consist of the column names that needed to be search. But when I add a variable I get an error saying incorrect syntax....
Can you not use a variable as a column list? I have a variable for search criteria and it works fine...
Here is my syntax
containstable([tablename],@.columnlist,@.srch)
I have been looking online and can't seem to find anything that says I can or cannot use a variable.
Column list cannot be replaced by variable. You have to use dynamic SQL to form and execute the SELECT statement if you want to parameterize CONTAINS/CONTAINSTABLE column list.
No comments:
Post a Comment