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.SMARTFIELDB6535CF1E6D743358C7471583510D9CF where @SMARTFIELDINSTANCEID = 'b6535cf1-e6d7-4335-8c74-71583510d9cf'
Union All
select null as ID, ID as IntID , VALUE as VALUE from dbo.SMARTFIELD8AB5D5F3AF844534B94B7F8BB279F3E1 where @SMARTFIELDINSTANCEID = '8ab5d5f3-af84-4534-b94b-7f8bb279f3e1'