USP_GLOBALCHANGECATALOG_GETINFORMATIONBYID

Retrieves information about a specific global change definition.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



        CREATE procedure dbo.USP_GLOBALCHANGECATALOG_GETINFORMATIONBYID
            (
                @ID as uniqueidentifier
            )
            as
            select
                GLOBALCHANGECATALOG.ID as GLOBALCHANGECATALOGID,
                GLOBALCHANGECATALOG.FORMMETADATAXML as GLOBALCHANGEFORMMETADATAXML,
                GLOBALCHANGECATALOG.DISPLAYNAME as GLOBALCHANGEDISPLAYNAME,
        GLOBALCHANGECATALOG.GLOBALCHANGESPECXML
            from
                dbo.GLOBALCHANGECATALOG
            where
                GLOBALCHANGECATALOG.ID = @ID;