> For the complete documentation index, see [llms.txt](https://docs.tailent.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tailent.com/actions/tap-actions/database/database-non-query.md).
# Database Non Query
This action can be used to execute a non query to a database, such as INSERT, UPDATE and DELETE statements, conection and returns an integer value representing the number of affected rows.
## Properties
### Input
* **Command:** The **SQL Command** which will be executed on the given tatabase connection;
* **Database Connection:** The DatabaseConnection object which will be used to interract with the SQL Server.
### Output
* **Result:** The resulting **int32** object returned by the query.
{% hint style="info" %}
**Note:** This object **must** have the **Variable Type** set **int32.**
{% endhint %}
### Misc
* **Display Name**: action display name in your implementation project.
* **Wait Before**: number milliseconds robot to wait before executing the action.
* **Wait After:** number milliseconds robot to wait until moving to the next action.
* **Abort on Error**: True/False.
* **Retry Times**: Specifies the number of times to retry an action if it doesn't end successfully. Default value 0 (no retry); Use -1 if you want to retry indefinitely.
## **Use Case**
### **Potential Use Cases**
* Directly Insert/Delete enteries in the invoices database based on predefined criteria.
{% embed url="" %}