USP_SEARCHLISTSETTINGS_CREATEORUPDATE
Used to insert or update the configuration settings for search lists
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEARCHLISTID | uniqueidentifier | IN | |
| @SETTINGSXML | xml | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.[USP_SEARCHLISTSETTINGS_CREATEORUPDATE]
@SEARCHLISTID uniqueidentifier,
@SETTINGSXML xml,
@CHANGEAGENTID uniqueidentifier = null
as
set nocount on;
if @CHANGEAGENTID is null exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
declare @existingID uniqueidentifier
select @existingID = ID from dbo.SEARCHLISTSETTINGS where ID = @SEARCHLISTID;
if @existingID is null
insert into dbo.SEARCHLISTSETTINGS (ID, SETTINGSXML, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
values (@SEARCHLISTID, @SETTINGSXML, @CHANGEAGENTID, @CHANGEAGENTID, getdate(), getdate());
else
update dbo.SEARCHLISTSETTINGS
set SETTINGSXML = @SETTINGSXML,
CHANGEDBYID = @CHANGEAGENTID,
DATECHANGED = getdate()
where ID = @SEARCHLISTID;
if @@error <> 0 return 1;
return 0;