Abstract
A stored procedure is a collection of SQL statements that allows you to perform a task repeatedly. You can create the procedure once and reuse it any number of times in your program. This can improve the maintainability of your application and allow applications to access the database in a uniform and optimized manner. The goals of this chapter are to get you acquainted with stored procedures by creating and modifying them in SQL Server 2012 and to explain how C# programs can interact with them. This chapter covers the following:
-
Creating stored procedures
-
Modifying stored procedures
-
Displaying the definitions of stored procedures
-
Renaming stored procedures
-
Working with stored procedures in C#
-
Deleting stored procedures
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Vidya Vrat Agarwal
About this chapter
Cite this chapter
Agarwal, V.V. (2012). Using Stored Procedures. In: Beginning C# 5.0 Databases. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4261-1_6
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4261-1_6
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4260-4
Online ISBN: 978-1-4302-4261-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books