Template for creating and testing SQL table-valued functions

SqlTableFunctionTemplate.sql

-- Template for creating and testing SQL table-valued functions 

IF EXISTS 
    (SELECT * FROM sys.objects 
        WHERE object_id = OBJECT_ID(N'ufnSomeFunction') 
        AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[ufnSomeFunction]
GO

CREATE FUNCTION [dbo].[ufnSomeFunction]
(
    @Var1 DATETIME, @Var2 UNIQUEIDENTIFIER
)
RETURNS TABLE

RETURN

SELECT * FROM SomeTable

GO

SELECT * FROM [dbo].[ufnSomeFunction](NULL, NULL)