Skip to content

Instantly share code, notes, and snippets.

@sinairv
Created September 17, 2012 06:43
Show Gist options
  • Save sinairv/3735872 to your computer and use it in GitHub Desktop.
Save sinairv/3735872 to your computer and use it in GitHub Desktop.
Template for creating and testing SQL table-valued functions
-- 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)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment