Exam objectives in this chapter:
Create Database Objects
Create and alter DML triggers.
Create and alter stored procedures (simple statements).
Work with functions.
T-SQL code can be stored within Microsoft SQL Server databases by using T-SQL routines such as stored procedures, triggers, and functions. This helps make your T-SQL code more portable, because it stays with the database and these routines will be restored from a database backup along with the database data. These routines can then be executed from the database as well. In this chapter, you learn about creating reusable T-SQL routines in stored procedures, triggers, and user-defined functions.
Lessons in this chapter: