Error obtained when using text, ntext, or image columns of INSERTED/DELETED tables (in triggers):
Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables.
Solutions:
1. Get the text field from the table itself, joining it to the INSERTED table on the primary key.
2. Use INSTEAD OF triggers.
No comments:
Post a Comment