SQL Server stored procedures - update column based on variable name..?
- by ClarkeyBoy
Hi,
I have a data driven site with many stored procedures. What I want to eventually be able to do is to say something like:
For Each @variable in sproc inputs
UPDATE @TableName SET @variable.toString = @variable
Next
I would like it to be able to accept any number of arguments.
It will basically loop through all of the inputs and update…