DB2,SQL Serverのロックの取得方法
SERIALIZABLEなロックの取得
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; select * from table where id=1; rollback;
select * from table where id=1 with rr; rollback;
SERIALIZABLEなロックの取得
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; select * from table where id=1; rollback;
select * from table where id=1 with rr; rollback;