Collections:
Other Resources:
"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?
2016-12-18, 381👍, 0💬
Popular Posts:
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To Create a View on an Existing Table in SQL Server? If you want to a view on an existing table,...