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屋!