SQL Server 2008: Merge Statement(sqlservercurry.com)
submitted by
vivekamar(5940) 3 years, 8 months ago
SQL Server 2008 introduced the Merge statement which is commonly also called as Upsert (Update / Insert). It can be used as Insert if the row does not exists and update, if it exists. It can be used as ETL process while fetching data. This feature is useful for developers. It is not required to give any particular join (inner, left outer etc).
|category: Database
|Views: 8
tags:
Database another
Everyones tags:
Your Tags: