spLoadRecord_NetAccount_ByUserID

Parameters

Parameter Parameter Type Mode Description
@ClientUsersID int IN

Definition

Copy



        CREATE PROCEDURE [dbo].[spLoadRecord_NetAccount_ByUserID]
            (
            @ClientUsersID int
            )
            AS

            SELECT 
            ID, 
            DisplayName, 
            EmailAddress, 
            ClientUsersID, 
            CreateDate, 
            UpdateDate,
            LockedOut, 
            LockedDate, 
            LockedUserID, 
            Deleted, 
            DeletedDate, 
            DeletedUserID,
            EmailForwardingEnabled,
            UserPageURL,
            OnlineStatus ,
            OnlineStatusPreferenceType,
            OnlineStatusUpdateDate,
            ProfileImageID
            from [NetAccount] where ClientUsersID = @ClientUsersID

            RETURN