If variable assignment must occur in a trigger, use a SET NOCOUNT statement at the start of the trigger to prevent the return of any result sets.

• 如果必须在触发器中进行变量赋值,则应该在触发器的开头使用SET NOCOUNT语句以避免返回任何结果集。