SQL Server 2014 Development Essentials

Summary

In this chapter, you declared and used local variables. You learned about control-of-flow statements and learned how to use them to control program execution. You understood the purpose of views, stored procedures, user-defined functions, and triggers, as well as understood the guidelines and restrictions to designing each of these programmable objects. You also learned how to design, create, and use views, stored procedures, user-defined functions, and triggers. In the last section, you learned how to handle errors that occur within Transact-SQL batches and programmable objects using the TRY...CATCH construct.