• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Designing SQL Server Stored P... > Modifying Data with Stored Procedure...

Modifying Data with Stored Procedures

Probably the most common use of a stored procedure is to modify the data in your database. You can easily design stored procedures to insert, update, and delete data. The sections that follow cover stored procedures that perform each of these tasks.

Inserting Data

Stored procedures are very effective at inserting data into your databases. Stored procedures that insert data generally contain several input parameters, one that corresponds with each field in the underlying table. They often contain OUTPUT parameters containing status or error information. Take a look at the following stored procedure:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint