与SQL比较(Comparing with SQL)

与SQL比较(Comparing with SQL)

我需要将一个excel列的值与sql数据库表中的列进行比较。 我该怎么做？

I need to compare the values of one excel column with the column in the sql database table. How will i do this?

最满意答案

一种方法是将Excel值导入临时SQL Server表（例如，使用SQL Server中的“ Import Data向导），然后使用几个好的SQL数据比较工具之一，如Red-Gate SQL Data Compare或ApexSQL SQL Data Diff比较SQL Server中的两个表。

One way would be to import the Excel values into a temporary SQL Server table (e.g. using the Import Data wizard in SQL Server) and then use one of the several good SQL data compare tools like Red-Gate SQL Data Compare or ApexSQL SQL Data Diff to compare the two tables in SQL Server.