SQL Server MERGE statement usage and examples

In this tip we look at how to use MERGE compared to running separate INSERT and UPDATE statements.

Using MERGE in SQL Server to insert, update and delete at the same time

In a typical data warehousing application, quite often during the ETL cycle you need to perform INSERT, UPDATE and DELETE operations on a TARGET table by matching the records from the SOURCE table.

Where's the error?

Understanding How to Use the UPDATE Statement to Change Your Data

Greg Larsen shows you a number of different ways to use the UPDATE statement to modify the data in your SQL Server tables.

Improving SSIS Update Performance

This article includes an examination of how I improved update performance. We examine four methods of loading data into a data warehouse.

A Hazard of Using the SQL Update Statement

If you've never encountered this quirk of the SQL UPDATE statement, you should take a look and find a simple way around it.

Update with CASE statement

Update Trigger to Store Only Updated Column and Former Value

History table needs individual rows for each column that has been updated, i.e., a column history.

Stairway to T-SQL DML Level 10: Changing Data with the UPDATE Statement

Unless you are working on a reporting-only application you will probably need to update tables in your SQL Server database. To update rows in a table you use the UPDATE statement. In this level we will be discussing how to find and update records in your database, and discuss the pitfalls you might run into when using the UPDATE statement.

Restricting updates?