O'Reilly logo

All-In-One MCITP SQL Server 2005 Database Developer by Darril Gibson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required