USP_DATALIST_SITES

List of all sites in the system.

Definition

Copy


CREATE procedure dbo.USP_DATALIST_SITES
as 

    set NOCOUNT on;

    select 
        [SITE].[ID],
        [SITE].[NAME],
        [SITE].[DESCRIPTION]

    from
        dbo.[SITE]

    order by
        NAME;