Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
Help on Stored Procedures needed... |
Sat, Feb 23 2008 4:40 AM | Permanent Link |
Felix | 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 |
Sat, Feb 23 2008 12:54 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Sat, Feb 23 2008 1:52 PM | Permanent Link |
Felix | Oh, thanks Roy. That helped.
Regards Felix |
Sat, Feb 23 2008 3:37 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Sun, Feb 24 2008 1:54 AM | Permanent Link |
Felix | Thanks Tim for this further explanation.
Regards Felix |
This web page was last updated on Monday, May 6, 2024 at 12:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |