David t's Blog – April 2010 Archive (1)

Compare the Rows of Two Tables

I regularly hear of people who want to compare the contents of two tables. For example, they have one table that is supposed to be a copy of another. Maybe it should be an identical copy. Or, maybe it contains a transformed version of the other's data. Whatever the case, they want to know if differences exist and they need more than just a simple count of rows from "select count(*)".

You can search the web and find all sorts of SQL query techniques to do this. Therefore,…

Added by david t on April 2, 2010 at 12:30am — 4 Comments

Featured Downloads

Try BLU Acceleration on Cloud

© 2018   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service