O'Reilly logo

Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours 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

HOUR 13. Important Stored Procedure Techniques

In the previous hour you learned the basics of working with stored procedures. To really be effective in working with stored procedures, you must learn additional techniques. In this hour you’ll learn about:

The SET NOCOUNT statement

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

How to work with input and output parameters

How to add error handling to your stored procedures

How to use stored procedures to modify data

How to add transaction processing to your stored procedures

The SET NOCOUNT Statement

The SET NOCOUNT statement, when set to ON, eliminates the xx row(s) affected message in the SQL Express Manager window. It also eliminates the DONE_IN_PROC communicated ...

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