与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.
更多推荐
发布评论