USP_DATALIST_FAF_IMAGES

Returns all FAF Images records.

Definition

Copy


CREATE procedure dbo.USP_DATALIST_FAF_IMAGES
as
    set nocount on;

    select 
        FAFIMAGES.[ID],
        FAFIMAGES.[CONSTITUENTID],
        FAFIMAGES.[EVENTID],
        FAFIMAGES.[NAME],
        FAFIMAGES.[DESCRIPTION],
        FAFIMAGES.[FILENAME],
        FAFIMAGES.[UPLOADFILENAME],
        FAFIMAGES.[IMAGETYPE],
        FAFIMAGES.[IMAGESIZE],
        FAFIMAGES.[IMAGECONTENT],
        FAFIMAGES.[CAPTION],
        FAFIMAGES.[APPROVED],
        FAFIMAGES.[PRIVATE],
        FAFIMAGES.[PHOTOGRAPHER],
        FAFIMAGES.[PHOTODATETAKEN],
        FAFIMAGES.[TAGS],
        FAFIMAGES.[EXTERNALFLAG],
        FAFIMAGES.[IMAGESOURCECODE],
        FAFIMAGES.[EXTERNALURL]
    from 
        dbo.FAFIMAGES