November 2001
Intermediate to advanced
504 pages
10h 18m
English
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 ...
Read now
Unlock full access