USP_USERSETTINGSDATAFORM_CREATEORUPDATE
Creates or updates a user's data form customization record.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @APPUSERID | uniqueidentifier | IN | |
| @PATH | nvarchar(4000) | IN | |
| @PARAMETERS | xml | IN |
Definition
Copy
create procedure dbo.USP_USERSETTINGSDATAFORM_CREATEORUPDATE(@APPUSERID uniqueidentifier,
@PATH nvarchar(4000),
@PARAMETERS xml)
as
begin
declare @EXISTINGID uniqueidentifier;
select @EXISTINGID = ID from dbo.USERSETTINGSDATAFORM where APPUSERID = @APPUSERID and [PATH] = @PATH;
if @EXISTINGID is null
begin
insert into dbo.USERSETTINGSDATAFORM (
APPUSERID,
[PATH],
PARAMETERS)
values (
@APPUSERID,
@PATH,
@PARAMETERS);
end
else
begin
update dbo.USERSETTINGSDATAFORM
set PARAMETERS = @PARAMETERS
where ID = @EXISTINGID;
end;
end;