Stored Procedures
Decided to stop putting off learning about this. *cough*
Starting reading up on it, seems fairly straight forward and simple and looks like stored procedures are alot like programming functions within the database?
Anyway, point being---I was gonna start messing around with them with my Access DB, but I couldn't find anything on it. Is this something that only high-end DB's have like Oracle & Sysbase? Thanks guys.
Peter J. Boettcher posted this at 19:17 — 8th May 2000.
They have: 812 posts
Joined: Feb 2000
RC,
Stored Procedures are mostly for DB Servers like SQL, Oracle, Sybase etc. Since they run without any user interaction they need to run on a server type db.
They can be used for things like cleanup duty (delete all records from last week), archive duty (backup all records from last week to backup table),bad record check (delete records where whatever is no good), and lots of other stuff.
Granted you can do all this stuff manually with web pages but it's totally automated with stored procedures.
Regards,
Peter J. Boettcher
PJ | Are we there yet?
pjboettcher.com
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.