Articles
Week 11: Articles
The article for this week focuses on learning how to use the MERGE
statement. The MERGE
statement is a conditional statement that lets you insert or update rows in a table.
The conditional logic of a MERGE
statement depends on your using an embedded query with an outer join. The inner join result typically updates the target row and the outer join result inserts new data into the table. However, you must also meet the logic of a comparison operation that you set in the MERGE
statement.
Articles