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.

Entering random data into a table

Este bloco de código tem o objetivo de demonstrar como podemos inserir um quantidade de linhas de registro de dados aleatórios de uma tabela no Microsoft SQL Server.

Can you prevent deletes and inserts without a WHERE clause from running?

Erik writes a script to do what it says on the tin.

OUTPUT Clause Basics (For Inserts and Deletes)

When INSERTING or DELETING rows from a table, the OUTPUT clause can be used to return a dataset containing the changes made. Mat Richardson explains how.

Insert Generator - Stored Procedure

Stored procedure to generate an insert script for a table.

SSIS

Comparing Multiple Rows Insert vs Single Row Insert with Three Data Load Methods

The performance of 'extract, transform, load' (ETL) processes for large quantities of data can always be improved by objective testing and experiment with alternative techniques. The cause of poor performance can sometimes be surprising.

T-SQL Bulk Insert

T-SQL that allows you to import tab delimited text file into correct table based on file name.

Stairway to T-SQL DML Level 9: Adding Records to a table using INSERT Statement

Not all applications are limited to only retrieving data from a database. Your application might need to insert, update or delete data as well. In this article, I will be discussing various ways to insert data into a table using an INSERT statement.