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