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, 1508🔥, 0💬
Popular Posts:
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...