USP_DATAFORMTEMPLATE_EDIT_SITE

Deprecated site edit routine.

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.
@NAME	nvarchar(250)	IN	Name
@DESCRIPTION	nvarchar(max)	IN	Description

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SITE
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @NAME nvarchar(250),
                @DESCRIPTION nvarchar(max)
            )
            as
                set nocount on;

                    declare @CURRENTDATE datetime;
                    set @CURRENTDATE = getdate();

                    if @CHANGEAGENTID is null  
                        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                    update 
                        dbo.SITE
                    set
                        NAME = @NAME,
                        DESCRIPTION = @DESCRIPTION,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where
                        ID = @ID;

                return 0;