如何读取未提交删除中的数据?
MS SQL 2008 过程删除然后插入数据。我需要能够在插入发生之前(即删除之后)读取另一个连接中的数据。我怎样才能做到这一点?
A MS SQL 2008 procedure deletes then inserts data. I need to be able to read data in another connection right up until the insert happens, i.e., after the delete. How can I accomplish this?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
我能想到的唯一可以自由读取已删除行而不阻止删除和插入的隔离级别是 快照隔离。但您必须在删除发生之前打开交易。
The only isolation level I can think of where you can freely read deleted rows, and not be blocking deletes and inserts, would be snapshot isolation. But you'd have had to have opened your transaction before the deletes occurred.