USP_DATAFORMTEMPLATE_ADD_WEBFORMSUSERREGISTRATIONPARTSETTING
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@ID | uniqueidentifier | INOUT | |
@CHANGEAGENTID | uniqueidentifier | IN | |
@SITECONTENTID | int | IN |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_WEBFORMSUSERREGISTRATIONPARTSETTING
(
@ID uniqueidentifier = null output,
@CHANGEAGENTID uniqueidentifier = null,
@SITECONTENTID integer
)
as
set nocount on;
if @ID is null
set @ID = newid()
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output
declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()
begin try
exec dbo.USP_WEBFORMSUSERREGISTRATIONPARTSETTING_ADDUPDATE
@ID,
@CHANGEAGENTID,
@CURRENTDATE,
@SITECONTENTID,
null,
null,
null,
null,
1
end try
begin catch
exec dbo.USP_RAISE_ERROR
return 1
end catch
return 0