USP_COMMUNICATIONS_GETSITEIMAGE

Gets an image from the image library by its ID.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	int	IN

Definition

Copy



create procedure dbo.USP_COMMUNICATIONS_GETSITEIMAGE
(
    @ID int
)
as
begin

select 
    NAME,
    IMAGETYPE,
    IMAGECONTENT,
    dbo.fnLastModifiedDate(GUID) as LASTMODIFIED
from 
    dbo.SITEIMAGES
where
    ID = @ID

end