Collections:
"CREATE FUNCTION" - Creating User Defined Functions in SQL Server
How To Create a Simple User Defined Function in SQL Server Transact-SQL?
✍: FYIcenter.com
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, 1917🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...