Do you mean you want to dynamically change the column to update in your SQL statement (and inside a procedure).
If that's correct, you cannot do it directly. Before jumping to solutions, in my opinion this isn't what you should even do unless you have strong reasons.
Don't know anything more about your goal but it looks like you're creating a procedure that would update a single column in a single row at a time. If it's true, why? For example, this may lead to excessive amount of round trips between the client and the database if several columns are updated in a single row. Also that kind of structure may lead to several other problems and extra coding.
Anyhow, if you need to execute dynamic SQL statements inside a procedure, you basically have two options:
-
EXECUTE[
^]
-
sp_executesql[
^]