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.
Parameter | Value |
---|---|
Connection Provider | Type of Connection String (Optional: provided by Connection Library). |
Connection String | Database Connection String (Optional: provided by Connection Library). |
CommandTimeout | The maximum time the SQL command can run before returning an error. |
Command | The 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] . |