Blog Pages

inserted/deleted with text/ntext/image in SQL Server triggers

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