Creating a Microsoft SQL Tag

After creating a tag and selecting an Microsoft SQL device, you will be expected to fill out the following fields:

SQL Query

Query string sent to the Microsoft SQL server.

Query Behavior

When a query is made successfully, Koios grabs the first column of the first row. Please ensure that you are only returning a single row and that the desired value is in the first column.

Read Only

Koios currently only supports SQL reads. An output tag cannot be used to write back to the database.

Disallowed Words

As an attempt to prevent an accidental SQL injection, the following words are disallowed in the query string:

• DELETE

• CREATE

• ALTER

• DEFAULT

• DROP

• DATABASE

• SET

• TRUNCATE TABLE

• UPDATE

Testing

Please be cautious using the SQL protocol, test your queries thoroughly to ensure there is no unintended consequences.