Louis van Alphen wrote:

>
> To touch upon an age-old subject:
>
> Can a feature be added to enable one to specify the maximum number of rows
> to be returned by a query. I know that this can be done with a SP, but
> using a SP for prohibits the use of a dynamic SQL query from a client where
> the client will specify the columns, WHERE clause, etc.
>

To review: Yes. It's possible to add such a feature especially since the engine
already supports that notion.

> I don't know if this is patr of the SQL standard though...

No, it's not part of the standard although several vendors seem to have settled
on a syntax of 'SELECT TOP <n> ...'.

>
> Thanks
>
> ------------------------------------------------------------------------
> Hot off the press- summer's here!
> School's out and it's sizzling hot. Whether you're planning a
> graduation party, a summer brunch, or simple birthday party,
> shop GreatEntertaining.com before your next celebration.
> http://click.egroups.com/1/4473/4/_/830676/_/959785649/
> ------------------------------------------------------------------------
>
> To unsubscribe from this group, send an email to:
> IB-Architect-unsubscribe@onelist.com