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