Execute Noe Query vs Execute Query What`s different ?

Execute Noe Query vs Execute Query What`s different ?

Hi
EXECUTE NON QUERY activity
Executes an non query statement on a database. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements, the return value is -1.
So here the output variable is a Int32 variable which will give us the affected records

Where as EXECUTE QUERY
Executes a query on a database and returns the query result in a Datatable
And here the output will be a datatable type

Cheers @dogebi

4 Likes

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