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

Submitted by: Administrator
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 GlobalGuideLineDatabase;
GO

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

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

Submitted by: Administrator

Read Online MS SQL Server Job Interview Questions And Answers