The MSSQL way is useful for some cases (simplifying the obtention
of result sets on SPs by client tools) but Firebird/Interbase way is
more complete because it allows client tools AND STORED PROCE-
DURES to get data from select stored procedures.
MSSQL SPs cannot get data from select procedures in the simple
way - only by cursors or explicit output parameters.
Interbase/Firebird way is more simple in the long run.
[]s Fabricio

On Wed, 7 Aug 2002 14:00:11 +0200, Gerhardus Geldenhuis wrote:

>Hi
>sql-server, I hear has the functionality in select procedures that it
>automatically "creates" output parameters for a select procedure if you do
>not specify it. This would be handy to have if you have a large set of
>output parameters.
>
>How do you view this. Would it be difficult to implement or is it in you
>opinion not necessary.
>
>I would imagine it might be difficult for the engine to decide when and how
>and with what to this with.
>
>Groete
>Gerhardus
>
>
>To unsubscribe from this group, send an email to:
>IB-Architect-unsubscribe@onelist.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>


[]s Fabricio
Systems Developer