UFN_SMARTFIELDINSTANCE_GETSTRINGVALUES
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SMARTFIELDINSTANCEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_SMARTFIELDINSTANCE_GETSTRINGVALUES(@SMARTFIELDINSTANCEID uniqueidentifier)
returns table
as
return
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELDD0D4B917537847F29B9544C864A75EDB where @SMARTFIELDINSTANCEID = '6cd704ab-420e-42f9-89eb-54c63c883016'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELDBF96C0BACE224B1D8AE44D038BCB2EC1 where @SMARTFIELDINSTANCEID = '847127bf-b8de-4db1-8659-0e3cbe6e9c7d'
Union All
select null as ID, ID as IntID , VALUE as VALUE from dbo.SMARTFIELD1365DDCEF051490296A3A1F8D3DB89E2 where @SMARTFIELDINSTANCEID = '1365ddce-f051-4902-96a3-a1f8d3db89e2'
Union All
select null as ID, ID as IntID , VALUE as VALUE from dbo.SMARTFIELDEC4A46B186ED4A6D82C12FF22B17CD74 where @SMARTFIELDINSTANCEID = 'ec4a46b1-86ed-4a6d-82c1-2ff22b17cd74'