Run querry - adding parameter only if not null

[michael.kiel]

Dear all,
I would like to update a DB table only for fields which have changed.
Instead of assembling the SQL statement manually I thought it would be better to use the run command activity and parameters.
How is it possible to update a DB table only for changed values that means to pass parameters to the activity only for changed fields?

[Anil_G (Anil Gorthi)]

@michael.kiel

Welcome to the community

you cannot do that…instead you can write an update query and run it inside loop checking what all are changed…pass the value and column name for those alone

cheers

[michael.kiel]

Thank you for your fast reply!