UFN_STUDENTSKILLCOURSE_GETMARKINGCOLUMN
Returns marking columns available for a skill on a course.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @STUDENTSKILLCOURSEID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_STUDENTSKILLCOURSE_GETMARKINGCOLUMN(
@STUDENTSKILLCOURSEID uniqueidentifier
)
returns table
as return
(
select
STUDENTSKILLCOURSEMARKINGCOLUMN.ID,
MARKINGCOLUMNDESCRIPTIONCODEID,
DESCRIPTION,
SEQUENCE
from dbo.STUDENTSKILLCOURSEMARKINGCOLUMN
join dbo.MARKINGCOLUMNDESCRIPTIONCODE on STUDENTSKILLCOURSEMARKINGCOLUMN.MARKINGCOLUMNDESCRIPTIONCODEID = MARKINGCOLUMNDESCRIPTIONCODE.ID
where STUDENTSKILLCOURSEID = @STUDENTSKILLCOURSEID
)