USP_ADORGANIZATIONALUNIT_EDIT

Updates an existing organizational unit in the ADORGANIZATIONALUNIT table

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@NAME	nvarchar(64)	IN
@OUPATH	nvarchar(1000)	IN
@GROUP	nvarchar(64)	IN
@USERNAMESUFFIX	nvarchar(10)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_ADORGANIZATIONALUNIT_EDIT
(
    @ID uniqueidentifier,
    @NAME nvarchar(64),
    @OUPATH nvarchar(1000),
    @GROUP nvarchar(64),
    @USERNAMESUFFIX nvarchar(10),
    @CHANGEAGENTID uniqueidentifier = null
)
as

set nocount on;

declare @CURRENTDATE datetime

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

set @CURRENTDATE = getdate()

begin try
    update dbo.ADORGANIZATIONALUNIT set
        [NAME] = @NAME,
        OUPATH = @OUPATH,
        [GROUP] = @GROUP,
        USERNAMESUFFIX = @USERNAMESUFFIX,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
    where ID = @ID

end try

begin catch
    exec dbo.USP_RAISE_ERROR

    return 1
end catch

return 0