Execute Update Query using Execute DB Query Activity

Automation Studio
1

Hi,

How to execute any ‘Update’ query as I can’t find any option in execute db query under query type drop down?

2

Hi,

Create a stored procedure containing the update query. Then, use the Execute DB Query activity with Database Operation=Stored Procedure.

Thanks,
Anshu

3

Hello,

Only Select Query option is coming in Database Operation.