---
title: "execute · RUAL Documentation"
description: "Executes provided query on the MSSQL server."
canonical: https://docs.rual.nl/block-types/mssql/mssqlconnection_query
language: en
---

# execute

This block is part of the [`mssql`](https://docs.rual.nl/block-types/mssql) group and was last modified in core [`v10.4.28`](https://docs.rual.nl/core-versions/100428).

Executes provided query on the MSSQL server.

- connection required `mssqlconnection`

- query required `value`

- params required `object`

- connection `mssqlconnection`

- results `array`

- affected `number`

- error `value`

A typical wiring for [execute](https://docs.rual.nl/block-types/mssql/mssqlconnection_query): [value](https://docs.rual.nl/block-types/value/value_default) feeds the `query` pin; the `connection` out pin feeds [close connection](https://docs.rual.nl/block-types/mssql/function_mssql_close_connection).

![Studio canvas example for the execute block: typical wiring for execute.](https://docs.rual.nl/canvas-examples/mssqlconnection_query.png)

### Version history

Introduced in [`v10.4.28`](https://docs.rual.nl/core-versions/100428).