USP_DATALIST_COURSE

CREATE procedure dbo.USP_DATALIST_COURSE
as
    set nocount on;

    select 
        COURSE.[ID],
        COURSE.[SCHOOLID],
        COURSE.[NAME],
        COURSE.[DESCRIPTION],
        COURSE.[COURSEID],
        COURSE.[ISINACTIVE]
    from 
        dbo.COURSE