Updating multiple tables in sql server 2016
Additionally, extra columns in the source dataset are added to the target dataset.
To prevent premature constraint violations you can temporarily suspend update constraints.
Or you might have application-specific validation checks that can raise custom errors during any stage of an update event.
For more information, see Validate data in datasets.
When you update a record in a dataset, there is the possibility of an error.
For example, you might inadvertently write data of the wrong type to a column, or data that's too long, or data that has some other integrity problem.
Search for updating multiple tables in sql server 2016:
When the merge is complete, if there are any constraints on the dataset that cannot be enabled, a Constraint Exception is thrown.