USP_DATAFORMTEMPLATE_PRELOAD_COURSEACADEMICCATALOGDEPARTMENT

The load procedure used by the edit dataform template "Course Academic Catalog Department Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ACADEMICCATALOGDEPARTMENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@SCHOOLID	uniqueidentifier	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_COURSEACADEMICCATALOGDEPARTMENT
(
    @ACADEMICCATALOGDEPARTMENTID uniqueidentifier,
    @SCHOOLID uniqueidentifier = null output
) 
as

    set nocount on;

    select  
        @SCHOOLID = SCHOOLID
    from
        dbo.ACADEMICCATALOGDEPARTMENT
    where   
        ID = @ACADEMICCATALOGDEPARTMENTID;

    return 0;