UFN_SMARTFIELDSITES_GET
Returns a table holding the ad-hoc query folders.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SMARTFIELDID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_SMARTFIELDSITES_GET
(
@SMARTFIELDID uniqueidentifier
)
returns table
as
return
(
select
SMARTFIELDSITE.ID,
SMARTFIELDSITE.SITEID,
SITE.NAME
from dbo.SMARTFIELDSITE
inner join dbo.SITE on SITE.ID = SMARTFIELDSITE.SITEID
where
SMARTFIELDID = @SMARTFIELDID
)