This topic has not yet been rated - Rate this topic

UPDATE (DMX)

SQL Server 2008

Changes the NODE_CAPTION column in the data mining model.


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

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.

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'

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions