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

Blogs

Power BI Monthly Digest – August 2020

By

In this month’s Power BI Digest Matt and I will again guide you through...

Daily Coping 14 Aug 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Setting default values for Array parameters/variables in Azure Data Factory

By

(2020-Aug-14) Setting default values for my parameters or variables in Azure Data Factory (ADF)...

Read the latest Blogs

Forums

Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

Location Data Privacy

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Location Data Privacy

TextBox Property>Action>GotoURL for Multiple Values?

By jbalbo

Hi I am using two stuff commands in my query. One gets the date...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers