January 2003
Intermediate to advanced
896 pages
19h 58m
English
Many system architects choose to use SQL Server stored procedures as part of their application designs, especially when a SQL Server is already being considered for data storage, because stored procedures provide centralized management of the SQL code, encapsulate all access to the data for performance tuning, and allow detailed security control. Stored procedures can be used for data retrieval, selection (to a given criteria), and manipulation.
Here are a few of the many advantages of using SQL Server stored procedures:
Central control of SQL code
Optimal speed for data operations
Transactional control
Data security
Data access control
Data selection and manipulation procedures common to all client applications
Some ...
Read now
Unlock full access