UFN_TRANSLATIONFUNCTION_BANKINGSYSTEMUNIVERSALNAME

Return

Return Type
nvarchar(50)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


                create function dbo.UFN_TRANSLATIONFUNCTION_BANKINGSYSTEMUNIVERSALNAME
                (
                    @ID uniqueidentifier
                ) 
                returns nvarchar(50
                as
                begin
                    declare @NAME nvarchar(50);

                    select 
                        @NAME = BANKINGSYSTEM.NAME 
                    from 
                        dbo.BANKINGSYSTEM
                    where
                        BANKINGSYSTEM.ID = @ID;

                    return @NAME;
                end