Collections:
"ALTER FUNCTION" - Modifying Existing Functions in SQL Server
How To Modify an Existing User Defined Function in SQL Server Transact-SQL?
✍: FYIcenter.com
If you find a mistake in an existing function previously created, you can drop (delete) it and create it again correctly. But dropping a function may affect other database objects who are depending on this function.
So the best way to correct a mistake in an existing function is to use the "ALTER FUNCTION" statement as shown in the following tutorial example:
USE FyiCenterData; GO -- Modifying an existing function ALTER FUNCTION Sundays() RETURNS INT AS BEGIN DECLARE @date DATETIME; DECLARE @count INT; SET @date = '2006-12-31'; SET @count = 0; WHILE DATEPART(YEAR, @date) < 2008 BEGIN SET @date = DATEADD(DAY, 1, @date); IF DATENAME(WEEKDAY, @date) = 'Sunday' SET @count = @count + 1; END; RETURN @count; END; GO Command(s) completed successfully.
Do you know what correction has been made on this function?
⇒ Creating User Defined Functions with Parameters in SQL Server
⇐ sys.sql_modules - Getting User Defined Function Definitions Back in SQL Server
2016-12-18, 1685🔥, 0💬
Popular Posts:
How To Present a Past Time in Hours, Minutes and Seconds in MySQL? If you want show an article was p...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...