Skip to main content

SQL Trigger

The SQL Trigger runs a SQL Query and uses the result to fire the trigger. It will run when a SQL Command returns a different DateTime value.

SQL Trigger

ParameterValue
Connection ProviderType of Connection String (Optional: provided by Connection Library).
Connection StringDatabase Connection String (Optional: provided by Connection Library).
CommandTimeoutThe maximum time the SQL command can run before returning an error.
CommandThe SQL Query to run the query must return a single result. Example Query that returns the maximum value of the Modified Column in the Table MyTable: SELECT MAX([Modified]) FROM [MyTable].