Include delete before insert
The include delete before insert option enables a delete statement to be added to the update procedure before any update or insert statement. This is a particularly useful option for purging old data and for updates based on a source system batch number. If this option is selected, the following dialog is displayed:
Use the wizard to build a where clause for the delete statement. Additional options included in this dialog are:
Issue warning if a delete occurs
Multiple pass delete - if this option is chosen, the delete is performed in a loop, 50000 rows at a time, until the required rows have been deleted.
Truncate table before insert - if this option is chosen, the delete is ignore and the Data Store Object is truncated.
The default for this field is off (i.e. a delete statement is not added to the procedure).
