Specifies the temporary named result set, also known as common table expression, defined within the scope of the INSERT statement. The result set is derived from a SELECT statement. For more ...

MERGE (Transact-SQL) [!INCLUDE SQL Server SQL Database] The MERGE statement runs insert, update, or delete operations on a target table from the results of a join with a source table. For example, ...