Hour 15. Working with Stored Procedures

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

Get Sams Teach Yourself ADO.NET in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial