Lesson 14. Stored Procedure Techniques Every Developer Should Know

The previous lesson covered the basics of working with stored procedures. To really be effective in working with stored procedures, you must learn additional techniques. In this lesson, you learn about:

Image The SET NOCOUNT statement

Image How to use the @@ functions in the stored procedures that you build

Image How to work with input and output parameters

How to add error handling to your stored ...

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.