update-dmx.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	ms.custom
UPDATE (DMX)	UPDATE (DMX)	minewiskan	owend	owend	02/17/2022	sql	analysis-services	reference	dmx

UPDATE (DMX)

[!INCLUDEssas]

Changes the NODE_CAPTION column in the data mining model.

Syntax

  
UPDATE <model>.CONTENT  
SET NODE_CAPTION='new caption'  
[WHERE <condition expression>]  

Arguments

model
A model identifier.

new caption
A string that contains the new name for the NODE_CAPTION column.

condition expression
Optional. A condition to restrict the values that are returned from the column list.

Examples

In the following example, the UPDATE statement changes the default name, Cluster 1, for cluster 001 to the more descriptive name, Likely Customers.

UPDATE [TM Clustering].CONTENT  
SET NODE_CAPTION= 'Likely Customers'  
WHERE NODE_UNIQUE_NAME = '001'  

See Also

Data Mining Extensions (DMX) Data Definition Statements
Data Mining Extensions (DMX) Data Manipulation Statements
Data Mining Extensions (DMX) Statement Reference