USP_DATAFORMTEMPLATE_ADD_MERCHANDISEPRODUCTIONOPTIONVALUE_PRELOAD

Parameters

Parameter Parameter Type Mode Description
@MERCHANDISEPRODUCTOPTIONID uniqueidentifier IN
@OPTIONCAPTION nvarchar(50) INOUT

Definition

Copy

create procedure dbo.USP_DATAFORMTEMPLATE_ADD_MERCHANDISEPRODUCTIONOPTIONVALUE_PRELOAD
(
    @MERCHANDISEPRODUCTOPTIONID uniqueidentifier,
    @OPTIONCAPTION nvarchar(50) = null output
)
as
    set nocount on;

    select 
        @OPTIONCAPTION = NAME
    from dbo.MERCHANDISEPRODUCTOPTION
    where ID = @MERCHANDISEPRODUCTOPTIONID;

    return 0;