Excel数据连接可以锁定数据库表吗？ [英] Can an Excel Data Connection lock a DB table?

问题描述

如果我将简单的Sql Server表数据连接添加到Excel工作表，如果连接从未关闭，是否可以锁定该表？

If I add a simple Sql Server table data connection to an Excel worksheet, can it lock that table if the connection is never closed?

推荐答案

通常的答案：是的，但这取决于具体情况……

The usual answer: yes, but it depends on the cicumstances ...

..主要取决于数据库采用的锁定策略（再次取决于组态）。我的假设是Excel将打开与数据库的常规连接。如果现在查询一个表，如果您具有悲观的锁定策略，则该表可能已经锁定了该表。

.. mostly on what locking strategy your database employs (again depending on the configuration). My assumption is that Excel would open a "regular" connection to the database. If you now query a table, that may already lock the table if you have pessimistic locking strategy.

希望这对您有帮助。与很多数据库系统有关。

Hope this helps .. there is tons of information out there on locking as related to a lot of database systems.

这篇关于Excel数据连接可以锁定数据库表吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！