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:
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 ...
Get Sams Teach Yourself T-SQL in One Hour a Day 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.
