QUERY_SQLSERVER

Deprecated version

This document refers to a deprecated version of the RQL programming language.

Please go here for documentation related to the latest supported version.

Queries the SQL Server database directly using SQL Server's SQL syntax.

Syntax

QUERY_SQLSERVER[<type>](database, query,
                  cache := <default interval>,
                  retries := <default int>, retry_interval := <default interval>)

The database argument corresponds to the database name registered in the "Credentials Service".

Example

QUERY_SQLSERVER("db01", "SELECT a, b, c FROM table1")