David Bird

Compare the Data in Two Tables

These queries are used to compare the data in two tables.   In these examples all the rows in each table is retrieved and compared using the UNION ALL command.  I would recommend adding additional WHERE criteria for very large tables to reduce the number of rows that will be compared.These SQL statements are based on […]

2007-08-09 (first published: )

2,752 reads

Blogs

Beginning T-SQL and Career Roadmap for Women (and Men)! #SQLSatBR

By

Download session materials and watch the recordings of my excellent sessions on Transact-SQL and...

Actual Kubernetes

By

This post continues looking at my process of learning more about Kubernetes. I’ve been...

New product: Azure Data Share

By

A brand new product by Microsoft called Azure Data Share was recently announced. It...

Read the latest Blogs

Forums

Primary Key and Clustered Index

By RonMexico

A topic I always get confused with is primary key vs. clustered index. I...

odd error message in function in a proc

By tcronin 95651

I have a cursor which has calls a function (sorry for  design this is...

How to make in memory SQL transformations within a data flow task

By svenflock

Hi all, first of all, I am new to Integration Services. I googled everything...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers