USP_APPUSER_EDIT

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@USERSID	varbinary	IN
@DISPLAYNAME	nvarchar(255)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure [dbo].[USP_APPUSER_EDIT]
    (
        @ID uniqueidentifier output,
        @USERSID varbinary(85),
        @DISPLAYNAME nvarchar(255),
        @CHANGEAGENTID uniqueidentifier
    )
    as
    begin
        set nocount on;

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

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

        update dbo.APPUSER
        set 
            USERSID = @USERSID,
            CHANGEDBYID = @CHANGEAGENTID,
            DISPLAYNAME = @DISPLAYNAME,
            DATECHANGED = @CURRENTDATE
        where ID = @ID;

        return 0;
    end