UFN_COURSE_GETCOURSEID

Return

Return Type
nvarchar(60)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


                create function dbo.UFN_COURSE_GETCOURSEID
                (
                    @ID uniqueidentifier
                )
                returns nvarchar(60)
                as
                begin
                    declare @COURSEID nvarchar(60);

                    select
                        @COURSEID = COURSEID
                    from
                        dbo.COURSE
                    where
                        ID = @ID;

                    return @COURSEID;
                end