Can a sql trigger value return more than 1 row, and 1 column?

Knowledge Drop

Last tested: Jan 16, 2019
 

According to docs, the sql_trigger_value will only consider the first row and column in the SQL you write. It is recommended to have your trigger value return only 1 value, to prevent confusion and protect non-streaming SQL dialects from loading large result sets into memory.

If you really want more than 1 column considered by your sql trigger value, you can concatenate the columns, which will cause it to trigger if there is a change in any of these columns.

This content is subject to limited support.                

Version history
Last update:
‎05-07-2021 09:48 AM
Updated by: