USP_DATAFORMTEMPLATE_EDIT_RESEARCHGROUP

Compatibility procedure for USP_DATAFORMTEMPLATE_EDIT_RESEARCHGROUP_2

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RESEARCHGROUP 
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @CURRENTAPPUSERID uniqueidentifier,
                @NAME nvarchar(100),
                @DESCRIPTION nvarchar(255)
            ) 
            as
            set nocount on;

            declare @SITES xml = null;
            exec dbo.USP_DATAFORMTEMPLATE_EDIT_RESEARCHGROUP_LOAD 
                @ID = @ID,
                @SITES = @SITES output;

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_RESEARCHGROUP_2
                @ID,
                @CHANGEAGENTID,
                @CURRENTAPPUSERID,
                @NAME,
                @DESCRIPTION,
                @SITES;