USP_SITEIMAGES_GETIDFROMURL

Parameters

Parameter Parameter Type Mode Description
@URL nvarchar(255) IN
@CLIENTSITESID int IN

Definition

Copy


CREATE procedure dbo.USP_SITEIMAGES_GETIDFROMURL(@URL nvarchar(255), @CLIENTSITESID int)
as
begin
    select ID, URL
    from dbo.[SiteImages]
    where 
        ClientSitesID = @CLIENTSITESID and 
        URL = @URL
end