Using User Defined Functions in SQL Server Transact-SQL

Q

Where to find answers to frequently asked questions on Using User Defined Functions in SQL Server Transact-SQL?

✍: FYIcenter.com

A

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.

 

⇒⇒SQL Server Transact-SQL Tutorials

2016-12-28, 263👍, 0💬