USP_DATAFORMTEMPLATE_ADD_EXPORTPROCESS

The save procedure used by the add dataform template "Export Process Add Form".

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier INOUT The output parameter indicating the ID of the record added.
@ADHOCQUERYID uniqueidentifier IN Ad-hoc query
@SMARTQUERYINSTANCEID uniqueidentifier IN Smart query instance
@CHANGEAGENTID uniqueidentifier IN Input parameter indicating the ID of the change agent invoking the procedure.
@NAME nvarchar(255) IN Name
@DESCRIPTION nvarchar(1000) IN Description

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_EXPORTPROCESS(
    @ID uniqueidentifier = null output,
    @ADHOCQUERYID uniqueidentifier = null,
    @SMARTQUERYINSTANCEID uniqueidentifier = null,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(255) = '',
    @DESCRIPTION nvarchar(1000) = '')
with execute as caller
as
    set nocount on;
    exec dbo.USP_EXPORTPROCESS_ADD @ID output, @ADHOCQUERYID, @SMARTQUERYINSTANCEID, @CHANGEAGENTID, @NAME, @DESCRIPTION;
    return 0;