Part III: Procedures and Triggers
Congratulations on finishing your second week! The third and final week will teach you how to write stored procedures and triggers. It also goes beyond syntax to prepare you for the real world of T-SQL programming. On Days 15 through 17, you will focus on stored procedures, which are T-SQL batches stored on the server that you can execute by name. On Days 18 and 19, you will learn how to write and test triggers.
On Day 15, "Writing and Executing Stored Procedures," you will learn the basic concepts of how to write and execute a simple stored procedure.
Then, on Day 16, "Optimizing Stored Procedures," you will see how to optimize a stored procedure so that they will run more efficiently.
Get Sams Teach Yourself Transact-SQL in 21 Days, Second Edition 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.
