If you’re using Execute query then that means you’re just trying to retrieve information from the database and store in a Datatable in Uipath.
If you’re trying to use update/insert queries then use “Execute non Query” and parameter directions need to be “IN”. Parameter names should be starting with “@” and must be equal to the column name from the database
Example : Query should look like “insert into dbo.TableName values (@Name, @Age)” and the parameter names section in your activity should have @Name followed by the direction and the datatype corresponding to the datatype of the DB column (eg. String should be used when it’s Varchar).
Let me know if this helps.