当前位置: 动力学知识库 > 问答 > 编程问答 >

OpenRowSet, OpenQuery, OpenDataSource - which is better in terms of performance

问题描述:

This can be a debatable answer, but I'm looking for the case where a local Excel file needs to be exported to a local SQL Server 2008' table.

Has anyone ever had the chance to check execution time to compare OpenRowSet/OpenQuery/OpenDataSource for a very large file import in SQL Server 2008?

I'm able to use any of the 3 options, and the query can be executed from anywhere. However, the data source (Excel) is in the same server as the SQL Server.

Any pointers would be helpful.

分享给朋友:
您可能感兴趣的文章:
随机阅读: