Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
User-defined functions are routines that can take parameters, perform calculations or other actions, and return a result. In Microsoft SQL Server 2005, you can write user-defined functions in any Microsoft .NET Framework programming language, such as Microsoft Visual Basic .NET or Microsoft Visual C#.
There are two types of functions: scalar, which returns a single value, and table-valued, which returns a set of rows.
The following table lists the topics in this section.
| Topic | Description |
|---|---|
Covers implementation requirements and examples of scalar-valued functions. |
|
Discusses how to implement and use table-valued functions (TVFs), as well as differences between Transact-SQL and common language runtime (CLR) TVFs. |
|
Describes how to implement and use user-defined aggregates. |
See Also
Other Resources
Understanding User-defined Functions