USP_DATAFORMTEMPLATE_PRELOAD_FACULTYACADEMICCATALOGDEPARTMENT_BYDEPARTMENT
The load procedure used by the edit dataform template "Faculty Academic Catalog Department By Department Add Data Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ACADEMICCATALOGDEPARTMENTID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @DEPARTMENTNAME | nvarchar(154) | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_FACULTYACADEMICCATALOGDEPARTMENT_BYDEPARTMENT
(
@ACADEMICCATALOGDEPARTMENTID uniqueidentifier,
@DEPARTMENTNAME nvarchar(154) = null output
)
as
set nocount on;
select
@DEPARTMENTNAME = NAME
from dbo.ACADEMICCATALOGDEPARTMENT
where
ID = @ACADEMICCATALOGDEPARTMENTID