CHAPTER 6Advanced Database Objects

In this chapter, you will learn about:

• Built-in functions

• User-defined functions

• DML triggers

• DDL triggers

• CLR-integrated database objects

Anyone who has never made a mistake has never tried anything new.

—Albert Einstein

We covered many of the basic database objects in earlier chapters. Now we'll discuss some of the advanced database objects: functions, triggers, and CLR integration. All of these objects work together to give DBAs many choices in solving a broad range of problems. You'll learn the benefits of each of these objects and how to use them to solve a wide variety of problems.

If you've never tried them before, expect to make some mistakes as you type them in. That's not a bad thing. ...

Get MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442) 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.