USP_DATAFORMTEMPLATE_ADD_COURSESTUDENTSKILL_PRELOAD
The load procedure used by the edit dataform template "Course Student Skill Add Data Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @COURSEID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @COURSENAME | nvarchar(75) | INOUT | Add to course |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_COURSESTUDENTSKILL_PRELOAD
(
@COURSEID uniqueidentifier,
@COURSENAME nvarchar(75) = null output
)
as
select
@COURSENAME = COURSEID + ' - ' + NAME
from dbo.COURSE where ID = @COURSEID