Tag Archives: Ways to compare and find differences for SQL Server tables

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 »