MS SQL Execute Scalar

This task will execute a scalar query (a query which returns a single result) against SQL Server. This is useful for fetching data to be used in Dashboards

Settings

Operation Timeout

Required
The maximum time to wait for the query to execute.

Query

Required
The SQL Query to be executed. See below for an example.

Connection

Required
The SQL Connection to use. See the Connecting to SQL Server article if you require more information on how to create/manage connections.

Zynk Settings

See Common Task Settings

Examples

You can find an example of how to use this task in the Using the SQL Connector tutorial.

Sample query, which will return the total balance across all accounts:

SELECT SUM(Balance) FROM Accounts