SQL Server Create delete custom function

Use Testgoifexists (SELECT* from sys.objects WHERE object_id = object_id (N'gettime') and typeinch(N'FN'N'IF'N'TF'N'FS'N'FT'))--determine if the custom function is present in the drop function gettime--Delete the Custom function Gocreate functions gettime (@t datetime)----Create a custom function with parameter returns datetime--return value type asbegin DECLARE @a datetime--declaring VariablesSet@a ='2014-02-01'--assign a value to the variablereturn@a--return EndSelectDbo.gettime ('2014-5-5')--Execute the function

SQL Server Create delete custom function