The previous lesson discussed several important stored procedure topics including how to take advantage of @@ functions, parameters, and error handling. There are several additional techniques that are extremely beneficial to know when working with stored procedures. In this lesson, you learn:
How to use stored procedures to modify data
How to add transaction processing to your stored procedures
Probably the most common use of a stored procedure is to modify the ...