Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - What Are User Defined Functions
(Continued from previous topic...)
What Are User Defined Functions?
A user defined function is a collection of Transact-SQL statements that stored in the SQL Server.
A user defined function will return data when executed.
A user defined function works in the same way as a system function.
It can be used as a scalar expression or a temporary table depending on the turning data format.
A system function is provided as part of the SQL Server.
But a user defined function must be created and managed by yourself.
If you are using a group of statements to calculate the same data repeatedly in different places,
you should consider to create a user defined function for that group of statements.
User defined functions are also called functions.
(Continued on next topic...)
- What Are User Defined Functions?
- What Are the Differences between User Defined Functions and Stored Procedures?
- How To Create a Simple User Defined Function?
- How To Use User Defined Functions in Expressions?
- How To List All User Defined Functions in the Current Database?
- How To Drop an Existing User Defined Function?
- How To Generate CREATE FUNCTION Script on an Existing Function?
- How To Get the Definition of a User Defined Function Back?
- How To Modify an Existing User Defined Function?
- How To Create User Defined Functions with Parameters?
- How To Provide Values to User Defined Function Parameters?
- Can You Pass Expressions to Function Parameters?
- How To Provide Default Values to Function Parameters?
- How Many Categories of Functions based Their Return Modes?
- How Many Ways to Create Table-Valued Functions?
- How To Create an Inline Table-Valued Function?
- How To Create an Multi-Statement Table-Valued Function?