How to manipulate TEXT, NTEXT data from sql server

问题:

i hard that TEXT, NTEXT data can not be manipulated from sql server trigger. is it true. if not then please explain how could i manipulate TEXT, NTEXT data from sql server trigger. thanks

回答1:

Don't use text or ntext. Use nvarchar(max) or varchar(max)

Harsh, but they have been deprecated for a reason...

Edit, just remembered. You may be able to use INSTEAD OF triggers