USP_USERPAGEHISTORY_CREATEORUPDATE
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @APPUSERID | uniqueidentifier | IN | |
| @PAGEID | uniqueidentifier | IN | |
| @HISTORY | xml | IN |
Definition
Copy
create procedure [dbo].[USP_USERPAGEHISTORY_CREATEORUPDATE]
@APPUSERID uniqueidentifier,
@PAGEID uniqueidentifier,
@HISTORY xml
as
set nocount on;
declare @RC int;
declare @date datetime;
set @date = getdate();
update dbo.USERPAGEHISTORY
set HISTORY = @HISTORY,
DATECHANGED = @date
where APPUSERID = @APPUSERID and PAGEID = @PAGEID;
set @RC=@@ROWCOUNT;
if @RC=0
insert into dbo.USERPAGEHISTORY (APPUSERID, PAGEID, HISTORY, DATECHANGED)
values (@APPUSERID, @PAGEID, @HISTORY, @date);
RETURN 0;