Summary

In this hour, you've seen how to work with stored procedures in a Microsoft SQL Server database. You saw how to use the SQL Enterprise Manager to create and edit stored procedures. Then you used the Query Analyzer to test a stored procedure and verify that it was returning data as expected. Finally, you saw how to call the stored procedure within ADO.NET and send and retrieve parameters.

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.