USP_COURSEFACULTYRESOURCE_DELETE

Executes the "Course Faculty Resource Delete" record operation.

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID uniqueidentifier IN Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy


CREATE procedure dbo.USP_COURSEFACULTYRESOURCE_DELETE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin

  update dbo.FACULTYCOURSE set ISRESOURCE = 0 where ID = @ID
    return 0;

end