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