You are here
Home > 2017 > September > 28

Merge statement in sql

MERGE STATEMENT We can merge data from a source table into a target table using merge statement. The practical use of merge statement in data warehousing and in OLTP (Online Transaction Processing). Syntax: Merge into <target_tablename> as T Using <source_tablename> as S ON <merge_condition> When matched then <update or delete action> When not matched by