"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 Expressions in SQL Server
⇐ Differences between Functions and Stored Procedures in SQL Server
2016-12-24, 3153🔥, 0💬
Related Topics:
