USP_DATALISTUSERDEFINED_DELETE

Executes the "User-defined Data List: Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy



CREATE procedure dbo.USP_DATALISTUSERDEFINED_DELETE(@ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier)
as
    set nocount on;

    begin try

        declare @CONTEXTCACHE varbinary(128);
        set @CONTEXTCACHE = CONTEXT_INFO();

        if @CHANGEAGENTID is not null
            set CONTEXT_INFO @CHANGEAGENTID;

        delete from dbo.DATALISTCATALOG
        where ID = @ID
            and dbo.UFN_DATALIST_ISUSERDEFINED(IMPLEMENTATIONTYPE, DATALISTSPEC) = 1;

        if @CONTEXTCACHE is not null
            set CONTEXT_INFO @CONTEXTCACHE;

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch;

    return 0;