Chapter 13. Creating Custom Functions

IN THIS CHAPTER

One of the newest advances in SQL Server 2000 is the ability to create custom functions. In previous versions of SQL Server, all functions were defined by the system developers and couldn't be modified in any way. In SQL Server 2000, developers can create their own functions that return any type of value. These functions can be used in stored procedures or as a column in a table as a computed column.

In this chapter, I cover the following:

  • New enhancements to SQL Server functions

  • User-defined functions

  • Functions that return a table

  • Calling user-defined ...

Get Writing Stored Procedures for Microsoft SQL Server 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.