Tag Archives: Quick and best way to Compare Two Tables in SQL

How to compare Columns of two tables in SQL Server

By | November 6, 2020

Background / Problem Statement – Many times while working on projects, we need to compare columns of two tables in sql server and find out what are matching columns and what are different columns in both the tables. Solution –  lets say we have below two tables, CREATE TABLE dbo.Employee ( EmployeeId INT ,fullName VARCHAR(100)… Read More »