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.SMARTFIELD0824C6500E6A40C3843993FBF049354B where @SMARTFIELDINSTANCEID = '0824c650-0e6a-40c3-8439-93fbf049354b'
Union All
select null as ID, ID as IntID , VALUE as VALUE from dbo.SMARTFIELD390E798DFD714DDDAD7B3B7639DB2EBD where @SMARTFIELDINSTANCEID = '390e798d-fd71-4ddd-ad7b-3b7639db2ebd'