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

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