Collections:
DEFAULT - Providing Default Values to Function Parameters in SQL Server
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL?
✍: FYIcenter.com
If you add a parameter when creating a stored procedure, you can provide a default value so that the execution statement is not required to pass input value to this parameter:
The tutorial exercise below shows you how provide default values to function parameters:
USE FyiCenterData; GO CREATE FUNCTION Age_In_Days ( @birth_date DATETIME, @today DATETIME = NULL ) RETURNS INT AS BEGIN IF @today IS NULL SET @today = GETDATE(); RETURN DATEDIFF(DAY, @birth_date, @today); END; GO -- Default value is used PRINT 'Age in days: '+STR( dbo.Age_In_Days('01-Jan-2007', DEFAULT)); GO Age in days: 138 -- Default value is not used PRINT 'Age in days: '+STR( dbo.Age_In_Days('01-Jan-2007', '11-May-2007')); GO Age in days: 130 -- Can not skip input values -- even for parameters with default values PRINT 'Age in days: '+STR( dbo.Age_In_Days('01-Jan-2007')); GO Msg 313, Level 16, State 2, Line 1 An insufficient number of arguments were supplied for the procedure or function dbo.Age_In_Days.
⇒ Categories of Functions Based on Return Modes in SQL Server
⇐ Passing Expressions to Function Parameters in SQL Server
2023-03-03, 29377🔥, 1💬
Popular Posts:
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...