Chapter 13. Functions

After completing this chapter, you will be able to

  • Retrieve data from a user or system function

  • Create a function using T-SQL

Functions are used to perform calculations that can be returned to a calling application or integrated into a result set. In this chapter, you will learn about the variety of system functions that ship with SQL Server. You will also learn how to create your own functions using T-SQL.

Note

Note

You can create triggers, functions, and stored procedures through Common Language Runtime (CLR) routines. Building code modules in a CLR-supported language such as C# .NET or Visual Basic .NET is beyond the scope of this ...

Get Microsoft® SQL Server® 2008 Step by Step 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.