UFN_COURSE_GETSCHOOLID
Returns the SchoolID for a given CourseID
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @COURSEID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_COURSE_GETSCHOOLID
(
@COURSEID uniqueidentifier
)
returns uniqueidentifier
as begin
declare @SCHOOLID uniqueidentifier;
select @SCHOOLID = dbo.COURSE.SCHOOLID
from dbo.COURSE
where dbo.COURSE.ID = @COURSEID
return @SCHOOLID;
end