C cytown Unregistered / Unconfirmed GUEST, unregistred user! 1999-09-22 #2 1. select时加上TABLOCKX(or tablock)参数 2. SET TRANSACTION ISOLATION LEVEL REPEATABLE READ 都可以锁定表,直到事务结束。
S silly Unregistered / Unconfirmed GUEST, unregistred user! 1999-09-22 #3 select * from TABLE1 holdlock