MS SQL tutorial on inserting missing data into table

This is a Microsoft SQL tutorial with a solution on inserting missing data into a table. This tutorial is for a situation where you have a duplicate table/database and need to insert missing data. This tutorial uses left outer join and NULL to work out which data is missing. It also deals with identity columns.

This video deals with the following issues:
An explicit value for the identity column in table ‘Training_Copy.dbo.employees’ can only be specified when a column list is used and IDENTITY_INSERT is ON.
Cannot insert explicit value for identity column in table ’employees’ when IDENTITY_INSERT is set to OFF.

Complimentary videos:
left outer join: https://youtu.be/aY3W9PEu1f8
working with multiple databases: https://youtu.be/Ql1lmagUpxg