SQL SERVER OBJECT TEMPLATES -- FUNCTION

Template for creating a function in sql server is given below:
-----------------------------------------------------------------------



/****************************************************************
*This script file creates the function FN_FUNCTION_NAME *
****************************************************************/
/******************************************************************
======== BEGIN MAINTENANCE WRAPPER ==========
******************************************************************/
-- Check if the function already exists


IF OBJECT_ID('dbo.FN_FUNCTION_NAME') IS NOT NULL
BEGIN-- If it exists, drop to recreate the function
DROP FUNCTION dbo.FN_FUNCTION_NAME
IF OBJECT_ID('dbo.FN_FUNCTION_NAME') IS NOT NULL
BEGINPRINT 'FUNCTION FN_FUNCTION_NAME DROPPED FAILED'
END
ELSE
BEGINPRINT 'FUNCTION FN_FUNCTION_NAME DROPPED SUCCESSFULLY'
END
END
GO
/******************************************************************
======== END MAINTENANCE WRAPPER ==========
******************************************************************/
/********************************************************
** REVISION HISTORY : *
** ====================== *
** DATE VERSION NAME COMMENTS *
** ---------- ------- ----------------- -----------------*
** MM/DD/CCYY 1.0 Developer Name Initial Draft *
** *
*****************************************************************
/
CREATE FUNCTION dbo.FN_FUNCTION_NAME(
/* Function parameters like
@pdtDate DATE
*/
)

RETURNS DATATYPE
-- Datatypes of output_parameter (Return parameter)
AS
BEGIN

/* Function Logic */
-- This will return the value output_parameter
RETURN output_parameter
END
GO
/******************************************************************
======== BEGIN MAINTENANCE WRAPPER ==========
******************************************************************/
-- Check for errors in creating the function

IF OBJECT_ID('dbo.FN_FUNCTION_NAME') IS NOT NULL
BEGIN
PRINT 'FUNCTION FN_FUNCTION_NAME CREATED SUCCESSFULLY'
END
ELSE
BEGIN
PRINT 'FUNCTION FN_FUNCTION_NAME CREATION FAILED'
END
GO
/******************************************************************
======== END MAINTENANCE WRAPPER ==========
******************************************************************/



This entry was posted in . Bookmark the permalink.

Leave a reply