O'Reilly logo

Sams Teach Yourself ADO.NET in 24 Hours by Paul Bertucci, Jason Lefebvre

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

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

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