Chapter 10. Enhancing Business Logic: User-Defined Functions (UDF)

Procedural languages are based mainly in the capability to create functions, encapsulate complex programming functionality, and return a value as a result of the operation. Using SQL Server 2000, you can define user-defined functions(UDF), which combine the functionality of stored procedures and views but provide extended flexibility.

This chapter teaches you the following:

  • What the built-in user-defined functions are and how to use them

  • How to define user-defined functions that return a scalar value

  • How to define user-defined functions that return a result set

  • How to convert stored procedures and views into user-defined functions

  • How to extend the functionality of constraints with ...

Get Microsoft® SQL Server™ 2000 Programming by Example 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.