spMFInsertValueList

Signature

EXEC dbo.spMFInsertValueList
    @Doc = N'<xml>',
    @isFullUpdate = 0,
    @Output = NULL OUTPUT,
    @Debug = 0;

Returns

INT: 1 on success; -1 on error.

Parameters

@Doc

  • Type: NVARCHAR(MAX)

  • Required: Yes

  • Description: Value list data (XML).

@isFullUpdate

  • Type: BIT

  • Required: No (default = 0)

  • Description: When set to 1 performs a full update.

@Output

  • Type: INT

  • Required: No (OUTPUT)

  • Description: Status or count output value.

@Debug

  • Type: SMALLINT

  • Required: No (default = 0)

  • Description: Debug level. - 1 = Standard Debug Mode - 101 = Advanced Debug Mode

Purpose

To insert ValueList details into MFValueList table.

Additional Info

Prerequisites

Warnings

Examples

Changelog

Date

Author

Description

2019-08-30

JC

Added documentation

2018-01-02

DEV2

Add RealObjectType flag