In the preceding hour, you saw various techniques for managing concurrency issues and eliminating points of contention for data in your application. In this hour, you'll learn how to work with stored procedures, which offer a superior way to access and modify the data in a database. Although stored procedures are offered on several different platforms, including Oracle, this hour concentrates on using stored procedures with Microsoft SQL Server.
In this hour, you'll learn how to
Use SQL Server Enterprise Manager to create and edit stored procedures
Use SQL Query Analyzer to test your stored procedures
Call a stored procedure from ADO.NET and retrieve the results of a query
Call a stored procedure and pass arguments to achieve dynamic functionality