David t's Blog Posts Tagged 'asntdiff' (1)

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,…