Msg 207, Level 16, State 1, Line 1 Invalid column name in "Dynamic SQL Query" error will come when we are not giving proper single quotes in declaration part. Please find the below issue and resolved screen shot for your reference.

Issue:

Resolved: