T-SQL: Merge Simplifies Development: Listing 1 10/21/2008 The MERGE statement uses the contents of a table-valued variable and updates a persistent table in the database. The USING clause specifies ...

The MERGE statement uses the contents of a table-valued variable and updates a persistent table in the database. The USING clause specifies the source of the update data.