O'Reilly logo

Microsoft® .NET Compact Framework (Core Reference) by Mark Sutton, Rory MacLoed, Robert Burbidge, Stephen Wheelwright, Andy Wigley

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using SQL Server Stored Procedures

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required