Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQs - Transact-SQL Understanding User_Defined_Functions

By: FYIcenter.com

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:

1. What Are User Defined Functions?
2. What Are the Differences between User Defined Functions and Stored Procedures?
3. How To Create a Simple User Defined Function?
4. How To Use User Defined Functions in Expressions?
5. How To List All User Defined Functions in the Current Database?
6. How To Drop an Existing User Defined Function?
7. How To Generate CREATE FUNCTION Script on an Existing Function?
8. How To Get the Definition of a User Defined Function Back?
9. How To Modify an Existing User Defined Function?
10. How To Create User Defined Functions with Parameters?
11. How To Provide Values to User Defined Function Parameters?
12. Can You Pass Expressions to Function Parameters?
13. How To Provide Default Values to Function Parameters?
14. How Many Categories of Functions based Their Return Modes?
15. How Many Ways to Create Table-Valued Functions?
16. How To Create an Inline Table-Valued Function?
17. 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...)