Write a SQL Server insert trigger

Feature: when a specific type of news is added, a specific background image is automatically appended. The first version (error message: text, ntext, or image Columns cannot be used in the inserted and deleted tables). The Code is as follows: (,) droptriggertgr_news_QA_inserttgr_news_QA_insertonnews,; id, @ new

Feature: when a specific type of news is added, a specific background image is automatically appended. The first version (error message: text, ntext, or image Columns cannot be used in the 'inserted' and 'deleted' tables). The Code is as follows: (,) drop trigger tgr_news_QA_insert on news ,; id, @ newstyp

Feature: when a specific type of news is added, a specific background image is automatically appended.

The first version (error message: text, ntext, or image Columns cannot be used in the 'inserted' and 'deleted' tables). The Code is as follows:

(,) Drop trigger tgr_news_QA_insert tgr_news_QA_inserton news,; id, @ newstype = newstypefrom insertednews id