Need to update specific columns in SQL table by matching the primary key.for updating the columns values are stored in a excel

Help Activities
, ,
1

The primary key is “LocatorID” column. By matching this need to update only three columns “Client Poc” and “Lastupdated” and “status” column.

image
image1149×64 3.95 KB

2

Hey @sathish_moorthy

Take Run Command activity and Use below query:

UPDATE YourTableName
SET 
    [Client Poc] = 'New Client Poc Value',
    Lastupdated = GETDATE(),
    status = 'New Status Value'
WHERE 
    LocatorID = '12345';

Screenshot for reference:

image
image964×294 11.9 KB

Execution of above query depends upon the datatype of the respective columns in database table. So, Modify values accordingly!

Regards,
Ajay Mishra

3

Hi @sathish_moorthy

Use LookUp to find the data from data Table and then use Execute non query,
Update Set command with Where clause to update the record.

Thanks

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.