ODBC guide

Update work item comment


Updates the text of an existing comment. Identify the comment by WorkItemId and Id in the WHERE clause; set the new Text in SET. Specify the project in WITH. Useful for correcting or expanding a comment after creation.

UPDATE WorkItemComments
SET Text='Updating <strong>html comment</strong> - updated on <<FUN_NOW>>'
Where WorkItemId=6455 and Id=5284411
WITH(Project='ProductTesting')