"CREATE FUNCTION" - Creating User Defined Functions in SQL Server

Q

How To Create a Simple User Defined Function in SQL Server Transact-SQL?

✍: FYIcenter.com

A

If you want to create a simple user defined function, you can use the "CREATE FUNCTION" command with a statement block in a simple format as shown in below:

CREATE FUNCTION function_name() 
   RETURNS data_type
   AS BEGIN
      statement_1;
      statement_2;
      ...
      statement_n;
      RETURN expression;
   END;
GO

The following tutorial exercise shows you how to create a simple user defined function:

USE FyiCenterData;
GO

CREATE FUNCTION Welcome()
   RETURNS VARCHAR(40)
   AS BEGIN
      RETURN 'Welcome to FYIcenter.com';
   END;
GO

PRINT dbo.Welcome();
GO
Welcome to FYIcenter.com

 

Using User Defined Functions in SQL Server Transact-SQL

⇒⇒SQL Server Transact-SQL Tutorials

2016-12-24, 319👍, 0💬