USP_CMSSECURITYGROUP_EDIT_1

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(65)	IN
@SITETASKSGROUP	bit	IN
@CONTENTTYPESCODE	int	IN
Definition

Copy

                    create procedure dbo.USP_CMSSECURITYGROUP_EDIT_1 (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,                        
                        @NAME nvarchar(65),
                        @SITETASKSGROUP bit,
                        @CONTENTTYPESCODE int
                    )
                    as

                        set nocount on;

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

                        declare @CURRENTDATE datetime
                        set @CURRENTDATE = getdate()

                        begin try
                            -- handle updating the data
                            update dbo.CMSSECURITYGROUP set
                                NAME = @NAME,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CURRENTDATE,
                                SITETASKSGROUP = @SITETASKSGROUP,
                                CONTENTTYPESCODE = @CONTENTTYPESCODE
                            where ID = @ID
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR
                            return 1
                        end catch

                    return 0;