阅读背景:

SQL Server ROWLOCK over SELECT如果不存在INSERT事务

来源:互联网 

I have upgraded from SQL Server 2005 to 2008. I remember that in 2005, ROWLOCK simply did not work and I had to use PAGELOCK or XLOCK to achieve any type of actual locking. I know a reader of this will ask "what did you do wrong?" Nothing. I conclusively proved that I could edit a "ROWLOCKED" row, but couldn't if I escalated the lock level. I haven't had a chance to see if this works in SQL 2008. My first question is has anyone come across this issue in 2008?I have upgraded from SQL Server 2005 to 2008. I




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: