Syntax options:

    IN lock-mode MODE | FOR lock-mode MODE

    Specifies the lock mode to be used for the specified tables and
    views. The IN and FOR keywords are synonymous. A table lock mode
    can be promoted, but cannot be demoted. For example, you can
    promote a SHARED READ lock to SHARED WRITE, but you cannot demote
    a SHARED WRITE mode to a SHARED READ mode.

    See the SET TRANSACTION statement for a description of these
    arguments.