Lesson 15. Power Stored Procedure Techniques

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:

Image How to use stored procedures to modify data

Image How to add transaction processing to your stored procedures

Modifying Data with Stored Procedures

Probably the most common use of a stored procedure is to modify the ...

Get Sams Teach Yourself T-SQL in One Hour a Day now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.