Hi all, Is there any smart service / functions we could use to execut

Question

Hi all,

Is there any smart service / functions we could use to execute SQL ?
Not just 'SELECT' but also 'INSERT' / 'UPDATE' ?

One of the solution might be: Create a store procedure which is "execute <Input parameter>" , <input parameter> is input of the store procedure. Use smart service 'Execute Store Procedure' to call such store procedure.

Is there any clever way to do so?
Thanks in advance,

vinayp0002 · Answer

Hi Rahul, 
 As I understand you need to execute multiple update statements 
 on a single table - write the query in the setup tab of the smart service (Query database) and give custom AC variable (ac!id ) which should be same as the column used as a filter. Then you can provide PV variable for that particular ac created in inputs.