Bulk Update: No value given for one or more required parameters

Help Studio
, ,
4

@Tadas , If we do have to Update Column Values based on a Condition we could use the Below Syntax to create the Sql Query and use it in the Non Execute Query Activity :

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

Example :

UPDATE Sheet1
SET column1 = value1, column2 = value2
WHERE column1<10;

Some other Posts Supporting the Query :

1 Like