Thanks in advancei am trying to update a table which contains xml type data fieldmy query is as followsUpdate ProductBaseset CrossSell.modify(' ')where CrossSell = 'NULL'i dont have any idea about what should be the value inside set CrossSell.modify( )
the CrossSell field contains null value nowi am trying to update the ProductBase table which contains CrossSell dtafield (xml type) with an inserted value which gets from clr trigger using xmlwriterplease help
Use IS NULL otherwise SQL tries to evaluate the xml column CrossSell as a character.
Hope this helps.
still iam getting error as ''Incorrect syntax near the keyword 'IS'
thanks for your quick response
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?