O'Reilly logo

MCITP SQL Server 2005 Database Administration All-in-One exam Guide 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 5 Advanced Database Objects

In this chapter, you will learn about:

• Built-in functions

• User-defined functions

• System stored procedures

• User-defined stored procedures

• DML triggers

• DDL triggers

• CLR integrated database objects

Share your knowledge. It's a way to achieve immortality.

—Dalai Lama

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

If you're ever trying to solve a problem that ...

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