UFN_MERCHANDISE_GETPRODUCTINSTANCEOPTIONS
Returns a list of a product instance's options.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PRODUCTINSTANCEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_MERCHANDISE_GETPRODUCTINSTANCEOPTIONS(@PRODUCTINSTANCEID uniqueidentifier)
returns table as
return
select
OPTIONNAME,
OPTIONVALUENAME,
OPTIONVALUEID,
PRODUCTINSTANCEOPTIONID,
OPTIONID
from dbo.UFN_MERCHANDISE_GETPRODUCTINSTANCEOPTIONS_2(@PRODUCTINSTANCEID)