UFN_SITEIMAGES_IMAGEURLSINUSE
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @URLS | xml | IN | |
| @CLIENTSITESID | int | IN |
Definition
Copy
create function dbo.UFN_SITEIMAGES_IMAGEURLSINUSE
(
@URLS xml,
@CLIENTSITESID int
)
returns table
as
return
(
select SI.URL
from @URLS.nodes('/URLS/U') URL(U)
inner join dbo.SITEIMAGES SI on SI.URL = URL.U.value('.', 'nvarchar(255)')
where SI.ClientSitesID = @CLIENTSITESID
)