USP_SEARCHLIST_COURSE_BYNAME

This provides the ability to search for a course by name.

Parameters

Parameter	Parameter Type	Mode	Description
@NAME	nvarchar(60)	IN	Course name
@COURSEID	nvarchar(12)	IN	Course ID
@SCHOOLID	uniqueidentifier	IN	School
@GRADELEVELID	uniqueidentifier	IN	Grade level
@ISINACTIVE	bit	IN	Course is no longer offered
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.
@SESSIONID	uniqueidentifier	IN	Session
@CHECKCOURSEGRADING	bit	IN	CHECKCOURSEGRADING
@CHECKCOURSERESTRICTION	bit	IN	CHECKCOURSERESTRICTION
@STARTTERMID	uniqueidentifier	IN	STARTTERMID

Definition

Copy



      CREATE procedure dbo.USP_SEARCHLIST_COURSE_BYNAME
      (
                @NAME nvarchar(60) = null,
                @COURSEID nvarchar(12) = null,
                @SCHOOLID uniqueidentifier = null,
                @GRADELEVELID uniqueidentifier = null,
                @ISINACTIVE bit = null,
                @MAXROWS smallint = 500,
                @SESSIONID uniqueidentifier = null,
                @CHECKCOURSEGRADING bit = 0,
                @CHECKCOURSERESTRICTION bit = 0,
                @STARTTERMID uniqueidentifier = null
            )
            as
                set nocount on;

                exec dbo.USP_SEARCHLIST_COURSE_SHARED @NAME, @COURSEID, @SCHOOLID, @GRADELEVELID, @ISINACTIVE, @MAXROWS, @SESSIONID, @CHECKCOURSEGRADING, @CHECKCOURSERESTRICTION, @STARTTERMID