带有(nolock)“的MS SQL Server 2008”相当于IBM DB2 9.7 [英] MS SQL Server 2008 "with (nolock)" equivalent for IBM DB2 9.7
本文介绍了带有(nolock)“的MS SQL Server 2008”相当于IBM DB2 9.7的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
在MS SQL Server 2008中,您可以这样写:
In MS SQL Server 2008 you can write like this:
FROM EMPLOYEE as A with (nolock)
DB2 9.7有相当的语法吗?谢谢
Is there an equivalent syntax for DB2 9.7? Thanks
推荐答案
DB2:Uncomitted Read = WITH UR
DB2: Uncomitted Read = WITH UR
SELECT * FROM whatevertable WITH UR
这篇关于带有(nolock)“的MS SQL Server 2008”相当于IBM DB2 9.7的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文