# Mssql Endpoint Properties

## `query` (string, required)

The SQL query used to write or to subscribe

Example: `"INSERT INTO test (some_column) VALUES (@some_column)"`

## `interval` (integer)

The amount of milliseconds between queries

## `cronExpression` (string)

The Cron expression used to poll the endpoint. (For examples, see: <https://github.com/node-cron/node-cron>)

Examples: `"1,2,4,5 * * * *"`, `"1-5 * * * *"`, `"*/2 * * * *"`, `"* * * January,September Sunday"`

## `validateQuery` (boolean)

Deprecated: This property has no effect anymore, please remove it from your files (Previous description: Validate the syntax of the SQL query)