Client/server server technology really began to take shape in the late 1980s and early 1990s. One technology that boosted its credibility was the stored procedure and trigger. Initially offered by Sybase in its SQL Server product, the technology today is supported by most major database vendors.
Stored procedures and triggers gained wide acceptance for several reasons:
They provide for the precompilation of SQL and procedural programming logic (if...then...else) into a tightly bound database object that can be invoked from a client or another server that is acting as a client to yet another server.
They provide performance advantages over dynamic SQL (i.e., SQL that originates at the ...