> What about the WITH LOCK clause of a select statement ?
>
> I had never used it, neither think I will need it in the near future,
> but how does it differ from the transaction parameter ?

The original question was "how to lock table".
Transaction parameter locks tables (such that transaction will not start
until it obtains all requested locks first).
WITH LOCK locks rows.

Ivan