What are the reasons for using 'exec' before a stored procedure. Seems
to work ok without it ?

"Peter" <peter.gamble@ntlworld.com> wrote in message
news:d8cba535.0311260441.6e54aeda@posting.google.c om...
> 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:rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------