UFN_PROSPECTPLAN_GETPLANNAME

Return

Return Type
nvarchar(100)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


                create function dbo.UFN_PROSPECTPLAN_GETPLANNAME
                (
                    @ID uniqueidentifier
                ) 
                returns nvarchar(100
                with execute as caller
                as begin
                    return 
                    (
                        select 
                            NAME
                        from 
                            dbo.PROSPECTPLAN
                        where
                            ID = @ID
                    )
                end