SQL Server waits for any object in transaction in the whole table before a SELECT happens. This totally threw me when I first learned about it. But the :lock option and Muz's addition in the adapter ...

In SQL Server, we can omit ";" for SELECT, UPDATE, INSERT or DELETE statement, but it looks we cannot omit ";" in MERGE statement. SQL Server MERGE statement needs an explicit ";" (semi-colon) at the ...