var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to check two tables?
I imported a table from a database to another one in same server. How to check if two tables have the same data?
SELECT * FROM Table1 JOIN Table 2
ON Table1.Col1 = Table2.Col1
AND Table1.Col2 - Table2.Col2
This query should return the same result on both tables, if they are the same:
select sum(cast(checksum(*) as bigint)) from YourTable
If this query return NULL, how about the next? Thanks
Originally Posted by blindman
Are you sure there is any data in the table at all?