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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.