USP_USERSETTINGSPAGE_CREATEORUPDATE_TABSETTINGS

create procedure dbo.USP_USERSETTINGSPAGE_CREATEORUPDATE_TABSETTINGS(@APPUSERID uniqueidentifier,
    @PAGEID uniqueidentifier,
    @TABSETTINGS xml)
as
begin
    declare @EXISTINGID uniqueidentifier;

    select @EXISTINGID = ID from dbo.USERSETTINGSPAGE where dbo.USERSETTINGSPAGE.APPUSERID = @APPUSERID and dbo.USERSETTINGSPAGE.PAGEID = @PAGEID;

    if @EXISTINGID is null
    begin

        insert into dbo.USERSETTINGSPAGE (
            APPUSERID,
            PAGEID,
            TABSETTINGS)
        values (
            @APPUSERID,
            @PAGEID,
            @TABSETTINGS);

    end
    else
    begin

        update dbo.USERSETTINGSPAGE
        set TABSETTINGS = @TABSETTINGS
        where ID = @EXISTINGID;

    end;
end