Hello Simon,

> > But, this isn't required perse. You can create a procedure
> > with a full body just fine.
>
> I appreciate it isn't required, I was thinking more in terms of

simplifying

> the sql script for updating and creating databases.
>
> If I have a product that is already in use and I want to modify an

existing

> stored procedure in the setup I will have to have a different sql script
> when using the same setup program to create a new database.
>
> If I use something like
>
> ALTER OR CREATE PROCEDURE SP_TEST ()
> AS
> BEGIN
> ...
> END;
>
> Then it shouldn't matter if I am updating an existing db or creating a new
> one.

Well, creating the procedures with empty bodies and filling them afterwards
does solve the "dependencies" problem easily with regard to calling other
procedures and procedures getting called from triggers :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com