Hi everybody,

as I am new to ElevateDB and just evaluating it: where can I find a simple explanation of
a "stored procedure"? I never worked with that and couldn't find rellay basic information
in the help-files.

Thanks a lot.

Felix

Felix


You won't find it in the manual, you'll need to buy one of the many books on SQL. Just do a search on Amazon for SQL.

Roy Lambert

Oh, thanks Roy. That helped.

Regards Felix

Felix,

<< as I am new to ElevateDB and just evaluating it: where can I find a
simple explanation of a "stored procedure"? >>

A stored procedure is simply an SQL script that is stored in the actual
database itself, and is executed from the context of the database in which
it is stored.  This means that it is normally restricted to only operating
on objects (tables, views, etc.) that are present in the same database.

Some database engines allow for dynamic SQL in stored procedures, some only
allow static SQL, and others offer both.  ElevateDB uses *only* dynamic SQL.
The difference is subtle, but important.  Dynamic SQL is not bound in any
way to the current database and is compiled "on-the-fly", whereas static SQL
is pre-compiled and statically bound to the database in which it resides so
that any attempt to drop or alter objects that are referenced in the SQL is
not permitted if it were to cause the SQL to subsequently fail.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks Tim for this further explanation.

Regards Felix