You cannot use the for browse clause in statements involving the union operator, or in cursor declarations.
The keyword holdlock is forbidden in a select statement that includes the for browse option.
The keyword distinct in the select statement is ignored in browse mode.
