June 2006
Beginner
456 pages
10h 3m
English
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:
• 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
SET NOCOUNT StatementThe 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 ...
Read now
Unlock full access