O'Reilly logo

Sams Teach Yourself T-SQL in One Hour a Day by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required