This one is nice to have while handling the table types may be anyone of you already know this.
Scenario: we passed the table type as parameter and we want to check upon
the database values and table type values, Then runtime decide the action to update/insert/delete the
Records in table.,
Performs insert, update, or delete operations on a target table based on the results of a join with a source table.
For example, you can synchronize two tables by inserting, updating, or deleting rows in one table based on differences found in the other table.
For more information: http://technet.microsoft.com/en-us/library/bb510625.aspx