Lesson 15. Power Stored Procedure Techniques
The previous lesson discussed several important stored procedure topics including how to take advantage of @@ functions, parameters, and error handling. There are several additional techniques that are extremely beneficial to know when working with stored procedures. In this lesson, you learn:
How to use stored procedures to modify data
How to add transaction processing to your stored procedures
Modifying Data with Stored Procedures
Probably the most common use of a stored procedure is to modify the ...
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.
