USP_DATALIST_SPONSORSHIPGREATESTNEEDGETSMARTFIELD
Get a smart field name given a smart from the Smart Field table.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_SPONSORSHIPGREATESTNEEDGETSMARTFIELD(@ID uniqueidentifier)
as
set nocount on;
select NAME
from dbo.SMARTFIELD
where ID = @ID