USP_USERSETTINGSSEARCHLIST_CREATEORUPDATE_PARAMETERS

Parameters

Parameter	Parameter Type	Mode
@APPUSERID	uniqueidentifier	IN
@SEARCHLISTCATALOGID	uniqueidentifier	IN
@PARAMETERS	xml	IN

Definition

Copy



create procedure dbo.USP_USERSETTINGSSEARCHLIST_CREATEORUPDATE_PARAMETERS(@APPUSERID uniqueidentifier,
    @SEARCHLISTCATALOGID uniqueidentifier,
    @PARAMETERS xml)
as
begin

    declare @EXISTINGID uniqueidentifier;

    select @EXISTINGID = ID from dbo.USERSETTINGSSEARCHLIST where APPUSERID = @APPUSERID and SEARCHLISTCATALOGID = @SEARCHLISTCATALOGID;

    if @EXISTINGID is null
    begin

        insert into dbo.USERSETTINGSSEARCHLIST (
            APPUSERID,
            SEARCHLISTCATALOGID,
            PARAMETERS)
        values (
            @APPUSERID,
            @SEARCHLISTCATALOGID,
            @PARAMETERS);

    end
    else
    begin

        update dbo.USERSETTINGSSEARCHLIST 
        set PARAMETERS = @PARAMETERS
        where ID = @EXISTINGID;

    end;

end;