Hmm… I have been using SQL for quite some time. But I do not know how to compare 2 tables to find out the different records. For example, I have 2 tables which are table A and table B. Both of them have some similar records. But I want to filter out the different data only. How can I do so? I searched online and discovered the method to do so. It is located in Microsoft SQL Server 2005 Books Online. All we need to do is use EXCEPT function in SQL.
Query to compare 2 tables to find the different
SELECT * FROM TableA EXCEPT SELECT * FROM TableB;
Query to compare 2 tables to find the matches
SELECT * FROM TableA INTERSECT SELECT * FROM TableB;
Hope this will help you too. 
Oh, before you play. This is the match and win game from PROLiNK online contest. Too bad that the contest ended. However, you still play the game here (I copied from waahhh.com website). You can also play over there, but registration is required. 
Congratulation to all the PROLiNK2u Online Game Contests Winners. Have you received your prize yet? I got mine on 21 March 2009. Have PROLiNK contacted you to collect your prize? No. No worry. Just drop them an email or call… You will get your prize in the end. Just a matter of time ~ long or short. For me, I took 2 months++ to get mine.
You all are really good
To my surprise… I received PROLiNK Online Game Contests prizes on 21 March 2009 afternoon. Gogi should call me when SkyNet Courier had picked up the prizes. Else I won’t not post ~ PROLiNK Malaysia ~ another slow slow company…
Thanks PROLiNK Malaysia for the Online Game Contests prizes
Hmm… I am not sure why. Several companies that I deal with lately are slow in response. I faced company like Advertlets that don’t/delay pay blogger money and no response or vary late response (after you post something at your blog, then they response). Citibank Malaysia ~ credit card department is another case. It took them more than 3 months to send the 2GB Philips GoGear Digital MP3 Player (I won’t get the gift if I don’t follow up). Here come another slow slow company ~ PROLiNK Malaysia.
We are in information age. You need to act fast else you will be far behind. I mentioned that I am the winner for PROLiNK2u Online Game Contests. And I won PROLiNK 19″ LCD monitor and PROLiNK wireless laser mouse. I could not wait to get my prizes that time. Therefore, I asked my PC supplier to help to get it for me because he knows PROLiNK staff (11 January 2009). PROLiNK staff promised him that will send the prizes before Chinese New Year. Woo, this is good. However, I still did not get anything after Chinese New year. So I contacted PROLiNK staff, Myke directly…
