UFN_ROUTINE_HASPARAMETER

            create function dbo.UFN_ROUTINE_HASPARAMETER
            (
                @ROUTINENAME nvarchar(128),
                @PARAMETERNAME nvarchar(128)
            )
            returns bit
            with execute as caller
            as begin
                declare @RETURNVALUE bit;
                set @RETURNVALUE = 0;

                if exists (select 1 from INFORMATION_SCHEMA.PARAMETERS where SPECIFIC_NAME = @ROUTINENAME and PARAMETER_NAME = @PARAMETERNAME)
                    set @RETURNVALUE = 1;

                return @RETURNVALUE;
            end