USP_APPSETTING_DELETE

create procedure dbo.USP_APPSETTING_DELETE
(
        @NAME nvarchar(100),
        @CHANGEAGENTID uniqueidentifier
)
            as
                set nocount on;

        declare @ID uniqueidentifier;

        select @ID = ID from dbo.APPSETTING
        where NAME = @NAME;

        if @ID is not null
        begin
            if @CHANGEAGENTID is null
                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

            exec dbo.USP_APPSETTING_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
        end