USP_COURSE_TOGGLEINACTIVE

Executes the "Course Toggle Inactive" record operation.

Parameters

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

Definition

Copy



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

            update dbo.COURSE set ISINACTIVE = 1 - ISINACTIVE where ID = @ID
              return 0;

          end