Uploaded January 2023 | Updated September 2026, 2 weeks ago

---

The `MERGE` statement probably one of the most powerful features in SQL Server, especially for data engineering tasks. Using the `MERGE` statement, we can insert, update, or delete rows based the differences found in a source and a target tables. Very similar to UPSERT if you are coming from other database systems or you have worked with web APIs.

In this video, I want to go over how to use the `MERGE` statement in MS SQL Server.

► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Paypal: paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🛒 By shopping on Amazon → amzn.to/2JkGeMD
👩‍💻 Follow me on Linked: linkedin.com/in/jiejenn
🌳 Becoming a Patreon supporter: patreon.com/JieJenn
✉️ Business Inquiring: YouTube@LearnDataAnalysis.org

#sql #sqlserver #dataengineering