Re: stored procedures

"Peter" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> What are the reasons for using 'exec' before a stored procedure.
Seems
> to work ok without it ?


Only when the stored procedure name is the first non-comment in the
SQL batch, may you omit the 'exec[ute]' keyword. In all other cases,
'exec' is mandatory. This is documented behaviour, BTW.

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of "Tips, Tricks & Recipes for Sybase ASE" and
"The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/shop

mailto:[EMAIL PROTECTED]
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------