UFN_NAMEFORMATFUNCTION_GETSEQUENCES

This SQL function returns all name format function sequences.

Return

Return Type
table

Definition

Copy



            create function dbo.UFN_NAMEFORMATFUNCTION_GETSEQUENCES()
            returns table
            as
            return
            (
                select
                    [ID],
                    case when len(NAMEFORMATFUNCTION.EXAMPLE) = 0 then
                        dbo.[UFN_NAMEFORMATFUNCTION_BUILDPROTOTYPE](NAMEFORMATFUNCTION.ID)
                    else
                        NAMEFORMATFUNCTION.EXAMPLE
                    end as EXAMPLE,
                    [SEQUENCE]
                from
                    dbo.NAMEFORMATFUNCTION
            )