In a database management system (DBMS), it is an SQL program that is stored in the database which is executed by calling it directly from the client or from a database trigger. When the SQL procedure is stored in the database, it does not have to be replicated in each client. This saves programming effort especially when different client user interfaces and development systems are used. Triggers and stored procedures are built into DBMSs used in client/server environments.
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2009 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- Navicat (PostgreSQL GUI) 8.2.17 (Windows)
- Navicat PostgreSQL GUI is a PostgreSQL database management tool, which can convert XML, CSV, MS Excel, MS Access, and popular data formats to PostgreSQL databases, eliminating time-consuming data entry and the errors that accompany it. Other useful major features include import and export wizard, schedule backup, batch job scheduling, data...
- Software downloads 2009-11-22
- Advanced ETL Processor 2.4.2.9 (Windows)
- Advanced ETL Processor extracts data from any database, transforms, validates it and loads into another database automatically. A unique technology called "What You See Is What You Load" saves a lot of time during testing and design of validation and transformation processes. It shows you how the data will be...
- Software downloads 2009-11-13
- FlippingBook PDF Publisher 0.5.6 (Windows)
- FlippingBook PDF Publisher is a Windows desktop application that helps you to produce remarkable online and offline Flash books with page flipping effect. No coding is required. Simply import your PDF, configure the look&feel and hit the publish button. Enjoy the real page flipping effect. Independence You are not tied...
- Software downloads 2009-11-10
- SQL Digger 2.5 (Windows)
- SQL Digger is a very simple search tool designed for Microsoft SQL Server. It enables you to search through all your SQL server database objects for any word in your TSQL statements. You're a DBA or DB developer working with Microsoft SQL Server? You've certainly already been in a situation...
- Software downloads 2009-11-01
- Advanced Message For Nokia (Mobile)
- It provides such professional functions and full of service as hiding and sending encrypting short message, filter harmful and spam short message, hiding short message from VIP automatically, displaying content which edited by yourself, creative chat model, chat system like MSN, sending a group of short messages and so on....
- Software downloads 2009-10-28
- Advanced Message For Nokia S60 5TH (Mobile)
- This software is specially designed for nokia phones. It provides such professional functions and full of service as hiding and sending encrypting short message, filter harmful and spam short message, hiding short message from VIP automatically, displaying content which edited by yourself, creative chat model, chat system like MSN and...
- Software downloads 2009-10-28
- "Most, if not all" Sidekick data recovered
- Well this is going to be interesting...So they had a catastrophic screw up and it looks like they worked their tales off to get it fixed.So that got a big black eye but at the same time it looks like they got it fixed. Whoever fixed this just got...
- Discussion threads 2009-10-15
- MobiMessage for S60 3rd Edition (Mobile)
- It provides such professional functions and full of service as hiding and sending encrypting short message, filter harmful and spam short message, hiding short message from VIP automatically, displaying content which edited by yourself, creative chat model, chat system like MSN, sending a group of short messages and so on....
- Software downloads 2009-09-29
- MobiMessage for S60 5th Edition (Mobile)
- It provides such professional functions and full of service as hiding and sending encrypting short message, filter harmful and spam short message, hiding short message from VIP automatically, displaying content which edited by yourself, creative chat model, chat system like MSN, sending a group of short messages and so on....
- Software downloads 2009-09-27
- DecryptSQL 3.0 (Windows)
- Do you have such kind experience that you can not view the complete SQL Script because of the reason with encryption when you view the Stored Procedure, View, Trigger, and Function of SQL2000/SQL2005/SQL2008? If yes, the DecrypSQL can help you to view the complete SQL Script quickly and exactly. It...
- Software downloads 2009-09-15
- SoftDream Oracle UnWrapper 1.1.58 (Windows)
- SoftDream Oracle UnWrapper is unwrapping software for Oracle 7/8i/9i/10g/11 with unwrapping package, package body, stored procedures, triggers, views, type. If you wrapped your own source code(pl/sql script) of package, procedures, triggers, views or user-defined functions with Oracle Wrap Util, but you neglectful lost it, the application can help you unwrapping...
- Software downloads 2009-08-26
- AllSync 3.3 (Windows)
- AllSync is the professional solution for your data synchronization, imaging, backup, update, replication and archiving needs under Microsoft Windows see operating systems. AllSync supports all storage media which can be accessed via a drive letter or network path. Various preconfigured copy modes are available for your copy tasks. A wide...
- Software downloads 2009-08-26
- Apple: 'Continues to study' Google Voice apps; AT&T: We played no part
- Apple, AT&T and Google have responded to an Federal Communications Commission inquiry into the Google Voice app flap. Apple says Google Voice apps interfere with iPhone functionality. AT&T says it had no role in the App Store approval process. If you recall, Google Voice related applications were booted from Apple's...
- Blog posts 2009-08-21
- Geek Sheet: Virtualizing Free Linux Distributions in Windows Server 2008 R2
- It's been a while since we've had a hardcore Geek Sheet installment, and I promise that this one will be a real winner. Some of you may be aware that the updated Hyper-V bare-metal hypervisor virtualization layer in Microsoft's upcoming Windows Server 2008 R2 (Which is due...
- Blog posts 2009-08-09
- Knobjex 2.02 (Windows)
- Knobjex short for Knowledge Objects is an information-manager that uses a networked approach to store information. Any item (or 'knowlegde-object') can can be linked to any other item. Allthough meant to be a knowledge-database, it can hold any type of data. Especially it has been adapted as a PIM-tool for...
- Software downloads 2009-07-23
- Xp_smtp 3.0 (Windows)
- Uses the MS SQL Server extended stored procedure xp_smtp to send email messages. To send email messages using this procedure you do not need to create a mail profile for the user account that is used to start an instance of MS SQL Server. Also it is not required to...
- Software downloads 2009-07-20
- DBDocumentor 4.50 (Windows)
- DBDocumentor produces database documentation for the SQL objects in your database project. Where SQLHelp only documents stored procedures, DBDocumentor operates on constraints, data views, user defined functions, indices indexes, stored procedures, tables, triggers, user defined data types, and security roles. DBDocumentor provides a fully cross referenced view of the SQL...
- Software downloads 2009-06-30
- RootReg 1.0 (Windows)
- Files that are created as self-registering have information that need to be stored in the Windows registry in order for the file to be available and useable to applications on the machine. Usually DLLs, and OCXs are self-registering and require to be registered on the machine. Normally you would have...
- Software downloads 2009-06-05
- Database Viewer Plus 1.0 (Mobile)
- View and update any database on iPhone. Synchronize database Wirelessly (3G, EDGE, Wi-Fi). Features: Supported Databases: Microsoft Access, Microsoft Excel, FilePro ,Oracle, SQL Server, DB2, MySQL, PostgreSQL, FoxPro, dBase, FileMaker Pro and any ODBC Compliant Database. Update data on the iPhone, which will reflect to your database on your PC...
- Software downloads 2009-05-22
- SoftDream Oracle UnWrapper 1.1.26 (Windows)
- SoftDream Oracle UnWrapper is unwrapping software for Oracle 7/8i/9i/10g/11 with unwrapping package, package body, stored procedures, triggers, views, type. If you wrapped your own source code(pl/sql script) of package, procedures, triggers, views or user-defined functions with Oracle Wrap Util, but you neglectful lost it, the application can help you unwrapping...
- Software downloads 2009-05-16
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- Reduce risk. Reduce complexity. Increase reliability.
-
A simplified IT environment isn't just less complex. It's also more reliable. Standardize on a single Linux platform with SUSE Linux Enterprise from Novell, and get the world's most interoperable Linux
- Learn more >>
- Keep Up With The Latest In Document Management with The DocuMentor.
-
Doc delivers the scoop on today's enterprise content management, printer maintenance, and all other issues related to document management. It's the DocuMentor Blog.
- Learn more >>
- Save time with automated shipping solutions
-
The Business Essentials Guide provides you useful tools and templates to help grow your business and save you time with automated shipping solutions.
- Visit the UPS Business Essentials Guide
- New Online Dashboard for IT Leaders
-
Read about top issues IT decision-makers face every day, plus get cost-effective solutions to real-life IT problems.
- Learn more >>
- Microsoft Dynamics CRM Online - Free Six-Month Trial for Eligible Organizations
-
Microsoft Dynamics CRM Online provides fast online access, simple contact management and better sales performance for a low monthly cost - the best value on the market today.
- Learn more about the free, six-month trial offer>>
SmartPlanet
- Thought-provoking progressive ideas on diverse topics that intersect with technology, business, and life, and matter to the world at large. Visit SmartPlanet
- More from IBM
-
- Can your business work smarter? Learn more about Lotus Symphony
- Learn how to work smarter and optimize cost using the IBM Smart SOA approach Download the eBook
- Smarter ways to make smarter products Read the brief from IBM
