USP_DATAFORMTEMPLATE_ADD_MERCHANDISEPRODUCT_PRELOAD

Parameters

Parameter	Parameter Type	Mode
@PICTURE	varbinary	INOUT
@PICTURETHUMBNAIL	varbinary	INOUT
@NAME	nvarchar(50)	INOUT
@DESCRIPTION	nvarchar(255)	INOUT
@MERCHANDISEDEPARTMENTID	uniqueidentifier	INOUT
@MERCHANDISEDEPARTMENTCATEGORYID	uniqueidentifier	INOUT
@VENDORID	uniqueidentifier	INOUT
@ISDISCOUNTABLE	bit	INOUT
@ONHANDQUANTITY	int	INOUT
@SALEPRICE	money	INOUT
@COST	money	INOUT
@HASOPTIONS	bit	INOUT
@OPTIONITEMS	xml	INOUT
@LOOKUPCODE	nvarchar(25)	INOUT
@PICTURECHANGED	bit	INOUT
@TAXID	uniqueidentifier	INOUT
@LOOKUPITEMS	xml	INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_MERCHANDISEPRODUCT_PRELOAD
                (
                    @PICTURE varbinary(max) = null output,
                    @PICTURETHUMBNAIL varbinary(max) = null output,
                    @NAME nvarchar(50) = null output,
                    @DESCRIPTION nvarchar(255) = null output,
                    @MERCHANDISEDEPARTMENTID uniqueidentifier = null output,
                    @MERCHANDISEDEPARTMENTCATEGORYID uniqueidentifier = null output,
                    @VENDORID uniqueidentifier = null output,
                    @ISDISCOUNTABLE bit = null output,
                    @ONHANDQUANTITY integer = null output,
                    @SALEPRICE money = null output,
                    @COST money = null output,
                    @HASOPTIONS bit = null output,
                    @OPTIONITEMS xml = null output,
                    @LOOKUPCODE nvarchar(25) = null output,
                    @PICTURECHANGED bit = null output,
                    @TAXID uniqueidentifier = null output,
                    @LOOKUPITEMS xml = null output
                )
                as
                set nocount on;

                    select
                            @TAXID = TAX.ID
                    from dbo.TAX
                    where TAX.DEFAULTFORMERCHANDISE = 1
                    and TAX.ISACTIVE = 1


                return 0;