read committedだと対象データ取得し終わった時点で 即ロック解放しちゃうのですね。 /* create table SampleA( ID int identity primary key, cnt int not null ) create table SampleB( ID int identity primary key, cnt int not null ) insert into Samp…

SQL with A( a ) AS ( SELECT 'A' UNION ALL SELECT 'B' UNION ALL SELECT 'C' ), N( n ) AS ( SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 ), J( j ) AS ( SELECT 'い' UNION ALL SELECT 'ろ' UNION ALL SELECT 'は' ) SELECT * FROM A FULL JOIN N ON…