A. With SQL 6.5 and below use the "set rowcount <n>" option.

This option is still available with SQL 7.0, but this supports the TOP() function as well which will optimise better so use this instead. "select TOP(n) from .........."