Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQs - Transact-SQL Understanding User_Defined_Functions
A collection of 17 FAQs on SQL Server Transact-SQL user defined functions. Clear answers are provided with tutorial exercises on creating and dropping user defined functions; defining and passing parameters into functions; providing and using parameter default values; defining and using table-valued functions.
Topics included in this FAQ are:
- 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?
Please note that all answers and tutorials are based on MS SQL Server 2005.
To follow tutorials in this collection, you should connect to SQL server
as a regular user who has enough permissions to run simple Transact-SQL statements.
To follow tutorial exercises in this collection, you need to use test tables created
from previous tutorial collections.
(Continued on next topic...)