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.