比较来自不同表的两行 [英] compare two rows from different table

问题描述

我在同一个数据库中有两个表.我想比较这些表中的行以生成日志文件，该日志文件包含两个表项中是否有任何更改的详细信息.

i have two tables in the same database.i want to compare the rows in these table to generate log files which have details if there is any change in the two table entries.

推荐答案

这可能会有所帮助:
http: //weblogs.sqlteam.com/jeffs/archive/2007/05/02/sql-server-2005-using-except-and-intersect-to-compare-tables.aspx [

This might help:
http://weblogs.sqlteam.com/jeffs/archive/2007/05/02/sql-server-2005-using-except-and-intersect-to-compare-tables.aspx[^]

Regards
Espen Harlinn

是比较，最快和最简单的比较sql表的方法 ^ ].

Shortes,fastest and easiest way to compare sql tables HERE[^].

您可以将JOIN Query语句与AND语句一起使用..

you use the statement of JOIN Query with AND statement..

这篇关于比较来自不同表的两行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！