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