When creating a trigger, the text, ntext, or image Columns cannot be used in the 'inserted' and 'deleted' tables.

1. Text, ntext, or image Columns cannot be used in the 'inserted' and 'deleted' tables

In

Create Trigger Trg On T1 Update

Change

 

 

Create Trigger Trg On T1 instead Of Update

Change for to instead of to access the binary field in the trigger. You do not need to query the binary field by ID.

 

 

2,

Data Types of text, ntext, and image cannot be compared or sorted unless the is null or like operator is used.

The preceding error may occur when you want to compare the inserted and deleted tables.