I have plenty of tables that have triggers on them to update new inserts with supporting information.
Example - Insert into child table tableX with basic information, grabs information from parent table tableY and adds to the child record. These fields are then filled in with the defaults from the Parent for ease of use, but can be overridden at the child level rather than strictly inherited.
The issue is that there are also plenty of tables where the insert already has all the information (e.g. copy existing rows to a new year, copy from an existing system etc.)
Is there any syntax or feature that would behave similar to this:
asked 07 Nov '16, 14:12