Chapter IV.2. Stored Procedures and Functions

Stored procedures and functions are invaluable tools that are available within database management systems. The stored procedures and functions that are installed when you install SQL Server 2008 allow you to do complex tasks without the need to program the complex details.

As a database developer, you can also create your own stored procedures and functions. These allow your users to do complex tasks without the need to program the complex details. However, in this case, you're the expert because you're the one who does the behind-the-scenes programming.

Get Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies® 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.