spDelete_UserRoles

Parameters

Parameter	Parameter Type	Mode	Description
@ClientUsersID	int	IN
@ClientRolesID	int	IN

Definition

Copy


            CREATE  Procedure [dbo].[spDelete_UserRoles]
            (
                @ClientUsersID int,
                @ClientRolesID int
            )
            AS
                IF @ClientUsersID > 0 
                BEGIN
                    DELETE FROM UserRoles WHERE ClientUsersID=@ClientUsersID AND ClientRolesID=@ClientRolesID
                END
                ELSE 
                    DELETE FROM UserRoles WHERE ClientRolesID=@ClientRolesID AND ManuallyAdded = 0