> For the complete documentation index, see [llms.txt](https://docs.keyfax.biz/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.keyfax.biz/product-suite/admin/entities/databoxes/sql-query/testing-sql-query-databoxes.md).

# Testing SQL Query Databoxes

This is best shown in an example. Once your SQL is crafted and appropriate Expressions have been added, click the **Test** button. As the description says, this query will return all columns from an Asset table. A number of Expressions will test or retrieve the returned data.

<figure><img src="/files/ircyKAyFk4JeDM75ggnR" alt=""><figcaption><p>Extracting data (here, from an external database connection)</p></figcaption></figure>

This will present a dialogue as shown below. In this example, you can see the DataBox **Import.AssetID** needs to be supplied; you should enter any test values and click **Evaluate**. In this case, **100** has been entered and in the **Results** section you can see the full result (which is provided in the form of an XML snippet) and the accompanying results of the Expressions:&#x20;

<figure><img src="/files/eTlYahTL4bK6sbmf3i2B" alt=""><figcaption><p>Testing your SQL query</p></figcaption></figure>

{% hint style="info" %}
Caution: it is important that your SQL queries return a single row of data - [read more here](/product-suite/admin/entities/databoxes/sql-query.md#multiple-rows-of-data).
{% endhint %}