Share via


Value Element (XMLA)

Contains the desired value of an Attribute element to be added by an Insert command, or a Cell element to be updated by an UpdateCells command.

Syntax

<Attribute> <!-- or Cell --!>
   ...
   <Value>...</Value>
   ...
</Attribute>

Element Characteristics

Characteristic Description

Data type and length

Any

Default value

None

Cardinality

1-1: Required element that occurs once and only once.

Element Relationships

Relationship Element

Parent elements

Attribute, Cell

Child elements

None

Remarks

For Attribute elements, the Value element contains the desired value that the member should contain after the Insert command is committed. For more information about inserting members, see Inserting, Updating, and Dropping Members (XMLA).

For Cell elements, the Value element contains the desired value that the cell should contain after the UpdateCells command is committed. The actual value stored in the writeback table for that cell is the difference between the original value of the cell and the desired value of the cell.

The data type used by this element should match the data type of the cell to be updated.

For more information about updating cells, see Updating Cells (XMLA).

See Also

Reference

CellOrdinal Element (XMLA)
Insert Element (XMLA)
UpdateCells Element (XMLA)

Concepts

Properties (XMLA)

Help and Information

Getting SQL Server 2005 Assistance