3.1.5.129 proc_UpdateUserInfoInTableFromRowUpdater

The proc_UpdateUserInfoInTableFromRowUpdater stored procedure updates the user information data for the specified user.

 PROCEDURE proc_UpdateUserInfoInTableFromRowUpdater(
       @SiteId                        uniqueidentifier,
       @UserId                        int,
       @Title                         nvarchar(255)      = NULL,
       @Email                         nvarchar(255)      = NULL,
       @IsActive                      bit                = NULL,
       @Locale                        int                = NULL,
       @CalendarType                  smallint           = NULL,
       @AdjustHijriDays               smallint           = NULL,
       @TimeZone                      smallint           = NULL,
       @Collation                     smallint           = NULL,
       @Time24                        bit                = NULL,
       @AltCalendarType               tinyint            = NULL,
       @CalendarViewOptions           tinyint            = NULL,
       @WorkDays                      smallint           = NULL,
       @WorkDayStartHour              smallint           = NULL,
       @WorkDayEndHour                smallint           = NULL,
       @MobileNumber                  nvarchar(127)      = NULL,
       @MUILanguages                  varchar(64)        = NULL,
       @ContentLanguages              varchar(64)        = NULL,
       @RequestGuid                   uniqueidentifier   = NULL OUTPUT
 );

@SiteId: The Site Collection Identifier (section 2.2.1.1.9) of the site collection containing the user whose information is to be updated.

@UserId: The User Identifier (section 2.2.1.1.13) for the user whose information is to be updated.

@Title: The user-friendly display name of the user. If this parameter is NULL, then the display name MUST be set to the empty string.

@Email: The email address of the user. If this parameter is NULL, then the email address MUST be set to the empty string.

@IsActive: A bit flag specifying whether the user is an active user in the site collection. This flag is set to 0 if the User is not an active user. This flag is set to 1 to indicate otherwise. If this flag is NULL, then the value MUST NOT be changed.

@Locale: An LCID specifying the preferred locale settings to be used when formatting and displaying UI for the user.

@CalendarType: The Calendar Type (section 2.2.1.2.3) to be used when processing date values for this user.

@AdjustHijriDays: If the @CalendarType parameter value is 6, then this parameter specifies the number of days to extend or reduce the current month in Hijri calendars for this User.

@TimeZone: The Time Zone Identifier for the time zone to be used when displaying time values for this User.

@Collation: The Collation Order (section 2.2.1.2.4) to be used when displaying information to this User.

@Time24: A bit flag which specifies whether to use a 24-hour time format when displaying time values to this User. If this parameter is set to 1, then the 24-hour time format is used; otherwise, the 12-hour time format is used.

@AltCalendarType: The Calendar Type of an alternate calendar for processing date values for this User.

@CalendarViewOptions: A Calendar View Options Type (section 2.2.3.1) which specifies the calendar display options setting for this User.

@WorkDays: A set of Workdays Flags (section 2.2.2.14) which specify the week days defined as the work week for this User.

@WorkDayStartHour: The start time of the work day for this user, in minutes from 12:00AM. For example, the value 480 indicates 8:00AM.

@WorkDayEndHour: The end time of the work day for this user, in minutes from 12:00AM. For example, the value 1020 indicates 5:00PM.

@MobileNumber: The user-friendly text field that specifies the mobile phone number of the user.

@MUILanguages: A string that contains the distinct culture(s) for the user's preferred display language(s), separated by semicolon. This string can be NULL.

@ContentLanguages: A string that contains the distinct culture(s) for the user's preferred content language(s), separated by semicolon. This string can be NULL.

@RequestGuid: The optional request identifier for the current request.

Return Values: This procedure returns an integer return code which MUST be 0.

This procedure MUST return no result sets.