Collections:
Creating User Defined Functions with Parameters in SQL Server
How To Create User Defined Functions with Parameters in SQL Server Transact-SQL?
✍: FYIcenter.com
Very often, you need to create a function with one or more parameters so that the function can be more generic. You only supply values to those parameters at the time of executing the function.
User defined functions with parameters can be created with the following syntax:
CREATE FUNCTION function_name ( @parameter_1 data_type, @parameter_2 data_type, ... @parameter_n data_type ) RETURNS data_type AS BEGIN statement_1; statement_2; ... statement_n; END;
The following tutorial exercise shows you how to create a function with one parameter called @url:
USE FyiCenterData;
GO
DROP FUNCTION Welcome;
GO
CREATE FUNCTION Welcome(@url VARCHAR(40))
RETURNS VARCHAR(40)
AS BEGIN
RETURN 'Welcome to '+@url;
END;
GO
PRINT 'Hi there, '+dbo.Welcome('dba.FYIcenter.com');
GO
Hi there, Welcome to dba.FYIcenter.com
⇒ Passing Values to User Defined Function Parameters in SQL Server
⇐ "ALTER FUNCTION" - Modifying Existing Functions in SQL Server
2016-12-18, 3331🔥, 0💬
Popular Posts:
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...