USP_QUERYVIEWEXTENSIONCATALOG_CREATEORUPDATEMETADATA

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@QUERYVIEWCATALOGID	uniqueidentifier	IN
@QUERYVIEWEXTENSIONXML	xml	IN
@ISATTRIBUTEEXTENSION	bit	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



        create procedure dbo.USP_QUERYVIEWEXTENSIONCATALOG_CREATEORUPDATEMETADATA
        (
            @ID uniqueidentifier,
            @QUERYVIEWCATALOGID uniqueidentifier,
            @QUERYVIEWEXTENSIONXML xml,
            @ISATTRIBUTEEXTENSION bit,
            @CHANGEAGENTID uniqueidentifier
        )
        as
        begin
            if @CHANGEAGENTID is null
                exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output

            declare @CURRENTDATE datetime = getdate();

            if exists(select 1 from dbo.QUERYVIEWEXTENSIONCATALOG where ID = @ID)
            begin
                update dbo.[QUERYVIEWEXTENSIONCATALOG] set
                    [QUERYVIEWEXTENSIONXML] = @QUERYVIEWEXTENSIONXML,
                    [ISATTRIBUTEEXTENSION] = @ISATTRIBUTEEXTENSION
                where ID = @ID;
            end

            else
            begin
                insert into dbo.[QUERYVIEWEXTENSIONCATALOG] (
                    [ID],
                    [QUERYVIEWCATALOGID],
                    [QUERYVIEWEXTENSIONXML],
                    [ISATTRIBUTEEXTENSION],
                    [ADDEDBYID],
                    [CHANGEDBYID],
                    [DATEADDED],
                    [DATECHANGED]
                ) values (
                    @ID,
                    @QUERYVIEWCATALOGID,
                    @QUERYVIEWEXTENSIONXML,
                    @ISATTRIBUTEEXTENSION,
                    @CHANGEAGENTID,
                    @CHANGEAGENTID,
                    @CURRENTDATE,
                    @CURRENTDATE
                )
            end
        end