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,760 reads

Blogs

Deployment of Microsoft SQL database with Azure DevOps

By

Hello, data folks! I have published several articles about databases and their maintenance in...

Reflection on Talking at SQLSaturday Charlotte About Mental Health

By

On December 7, I did a session on mental illness and mental health problems...

A guide to acronyms, abbreviations, and other technical terms

By

Here’s a list of some technical terms, acronyms, and abbreviations you may have heard,...

Read the latest Blogs

Forums

reference table for errors

By samirca007

Hello everyone I have on each table of my base two columns used to...

Can we send temp table as parameter from one store procedure to store procedure

By Rock

I need to send a temp table as parameter from one store procedure to...

Backup rows tables of SQL Server database by SMO base on colums's value

By test0101

I am following this article to backup database, but in that, will be backup...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers