FunctionName Attribute

The FunctionName attribute is a required attribute for the TVFImplementation element. This attribute provides the name of the database object for the table-valued function. The custom table-valued function must be prefixed with "USR_" to avoid name collisions with future updates from Blackbaud.

Tip: Prefixing Certain Custom SQL Objects with "USR_" is one of the 7 Commandments of Infinity Development and is part of our Best Practices.

<TVFImplementation FunctionName="USR_UFN_QUERY_FOODBANKTXDETAIL_LISTBUILDER2">
    <CreateFunctionSQL>

      create function dbo.USR_UFN_QUERY_FOODBANKTXDETAIL_LISTBUILDER2(@FOODBANKID uniqueidentifier = null)
      returns table
      as
      RETURN
      WITH CTE
      AS ...