UFN_COURSE_GETSELECTEDDEPARTMENTSCODE
Returns the Selected Departments Code for Course.
Return
| Return Type |
|---|
| tinyint |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @COURSEID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_COURSE_GETSELECTEDDEPARTMENTSCODE(@COURSEID uniqueidentifier)
returns tinyint
with execute as caller
as begin
declare @retval tinyint
select
@retval = SELECTEDDEPARTMENTSCODE
from dbo.COURSE
where
COURSE.ID = @COURSEID
return @retval
end