USP_DATALIST_SMARTFIELDINSTANCESBYCATALOGID
Given a smart field catalog ID, retrieve a list of associated smart field instances.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CATALOGID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_SMARTFIELDINSTANCESBYCATALOGID
(
@CATALOGID uniqueidentifier
)
as
set nocount on;
select ID, NAME
from dbo.SMARTFIELD
where SMARTFIELDCATALOGID=@CATALOGID
order by NAME;
return 0;