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.