tag:blogger.com,1999:blog-74461682198493596462024-02-08T05:38:17.051-08:00SQL Server Comparison ToolAnonymoushttp://www.blogger.com/profile/16827021960388887336noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-7446168219849359646.post-50128414167301816172012-11-10T18:01:00.000-08:002012-11-10T18:01:39.297-08:00Finding records missing in target table<span style="font-family: Georgia,"Times New Roman",serif;">Often there is a need to find records which exist in source table but not in target table.<br />This can be achieved with simple SQL statement:<br /><br /><span style="font-family: "Courier New",Courier,monospace;"><span style="color: blue;">SELECT</span> <span style="color: #666666;">*</span> <span style="color: blue;">FROM</span> t1 <span style="color: blue;">WHERE</span> <span style="color: #666666;">NOT EXISTS</span> (<span style="color: blue;">SELECT</span> <span style="color: #666666;">*</span> <span style="color: blue;">FROM</span> t2 <span style="color: blue;">WHERE</span> t2.Id = t1.Id)</span><br /><br />or<br /><br /><span style="font-family: "Courier New",Courier,monospace;"><span style="color: blue;">SELECT</span> <span style="color: #666666;">*</span> <span style="color: blue;">FROM</span> t1 <span style="color: #666666;">LEFT OUTER JOIN</span> t2 <span style="color: blue;">ON </span>t1.Id = t2.Id <span style="color: blue;">WHERE</span> t2.Id <span style="color: #666666;">IS NULL</span> </span><br /><br />This works not only for SQL Server, but also for many other databases.</span>Anonymoushttp://www.blogger.com/profile/16827021960388887336noreply@blogger.com0