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

Get Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial