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