The MERGE statement in SQL Server allows us to perform INSERT, UPDATE, and DELETE operations in a single query. This makes it an efficient way to synchronize two tables, typically between a source and a target, based on a defined condition. Rather than running separate queries to handle insertions, updates, and deletions, we can combine all of these operations into one statement; the MERGE statement.
Tag: tutorial
SQL Tutorial for Beginners
In this SQL tutorial for beginners, you will create your own database, insert data into that database, and then run queries against that database.
This SQL tutorial will get you running SQL queries in no time!
Continue readingDatabase Tutorial (Part 2) – Relationships, Adding Data, Querying Databases
This article is part 2 of the database tutorial.
Here, we cover:
- Relationships
- The different ways of adding data to a database
- Querying a database
Database Tutorial (Part 1) – About Databases, Creating Databases, Tables
This article is part 1 of the database tutorial.
Here, we cover the following:
- What is a database?
- What is a Database Management System (DBMS)?
- Types of databases
- What does a relational database look like?
- Creating a database
- Creating tables
- Data types
Database Tutorial
This database tutorial is for beginners. It explains basic concepts and assumes no prior knowledge of databases.
You don’t need to follow along – there aren’t any exercises. But there are plenty of screenshots and a few diagrams. The purpose of the tutorial is to introduce you to the basic concepts of databases.
Microsoft Access Tutorial (Part 3): Queries, Forms, & Macros
This article is Part 3 of the Microsoft Access tutorial.
Here’s what’s included in this article:
- Create a query (so you can “search the database”).
- Create a form for data entry.
- Create a macro (so that a multi-step task can be done automatically – at the click of a button).
Microsoft Access Tutorial (Part 2): Design View, Field Properties, & Relationships
This article is Part 2 of the Microsoft Access tutorial.
Here’s what’s included in this article:
- Design View.
- Add field properties to a field.
- Add two more tables (for the relationship)
- Set up a relationship between three tables.
Microsoft Access Tutorial (Part 1): Databases, Tables, & Fields
This article is Part 1 of the Microsoft Access tutorial.
Here’s what’s included in this article:
- Create a database.
- Add a table to the database.
- Add four fields to the table, name/rename them, and set up their data type.
Microsoft Access Tutorial
This Microsoft Access tutorial will show you how to use Microsoft Access to create a simple database with all the common features such as tables, forms, queries, and macros.
This tutorial is for beginners. No prior database knowledge is assumed.