Using User Defined Functions in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Using User Defined Functions in SQL Server Transact-SQL?
✍: FYIcenter.com
Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team
on Using User Defined Functions in SQL Server Transact-SQL.
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.
What Are User Defined Functions in SQL Server
Differences between Functions and Stored Procedures in SQL Server
"CREATE FUNCTION" - Creating User Defined Functions in SQL Server
Using User Defined Functions in Expressions in SQL Server
sys.objects - Listing All User Defined Functions in SQL Server
"DROP FUNCTION" - Dropping an Existing User Defined Function in SQL Server
Generating CREATE FUNCTION Scripts on Existing Functions in SQL Server
sys.sql_modules - Getting User Defined Function Definitions Back in SQL Server
"ALTER FUNCTION" - Modifying Existing Functions in SQL Server
Creating User Defined Functions with Parameters in SQL Server
Passing Values to User Defined Function Parameters in SQL Server
Passing Expressions to Function Parameters in SQL Server
DEFAULT - Providing Default Values to Function Parameters in SQL Server
Categories of Functions Based on Return Modes in SQL Server
Syntaxes of Creating Table-Valued Functions in SQL Server
"RETURNS TABLE" - Creating Inline Table-Value Functions in SQL Server
Creating Multi-Statement Table-Value Functions in SQL Server
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.
2016-12-28, 353👍, 0💬