Home >Database >Mysql Tutorial >解决获取某张表信息的时候不发生共享锁
解决获取某张表信息的时候不发生共享锁
- WBOYOriginal
- 2016-06-07 14:54:411260browse
本文来自CNBLOG日志，感觉不错，现在来分享 具体可查看：http://www.cnblogs.com/Charles2008/archive/2010/12/15/MyTransactionStudy.html 共享锁 ----采用with nolock关键字或者采用Read uncommited就可以解决了。最终的SQL语句如下：SELECT Field FROM TAB
本文来自CNBLOG日志，感觉不错，现在来分享具体可查看： http://www.cnblogs.com/Charles2008/archive/2010/12/15/MyTransactionStudy.html 共享锁
----采用with nolock关键字或者采用Read uncommited就可以解决了。最终的SQL语句如下： SELECT Field FROM TABLE WITH NOLOCK
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：从T-SQL中创建Excel的XLS格式文件Next article：Accessa如何在表添加现有字段