The include insert statement option includes an insert statement in the procedure to insert new rows in the Data Store Object. If this option is chosen, then the New rows only option is available. Choosing this option, displays the code type drop down, enabling the generated update statement to use either a sub-select with except change detection or checksum change detection to work out what rows in the source table(s) are new. If this option is turned off, the update procedure will not contain an insert statement. The default for this field is on (i.e. an insert statement is included).