Indentifies destinations for the results of a Query statement or Insert Values statement.
The following sections describe two variants of the INSERT clause. The Query statement and Insert Values statement must begin with this clause. You can use either variant to begin a Query statement. However, an Insert Values statement must use the INSERT INTO form of the INSERT clause.
INSERT INTO form: Identifies a single destination for the results of a Query statement or Insert Values statement
INSERT WHEN form: Identifies multiple destinations for the results of a single Query statement, creating a branch. Rows are inserted into one of the specified destinations based on one or more conditions applied against the query's SELECT list.