O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required