sql-server - CREATE TRIGGER 必须是批处理中的第一个语句

Question

我有以下触发器:

 CREATE Trigger enroll_limit on Enrollments
 Instead of Insert
 As
 Declare @Count int
 Declare @Capacity int
 Select @Count = COUNT(*) From Enrollments
 Select @Capacity = Capacity From CourseSections
 If @Count < @Capacity
 Begin 
      Insert Into Enrollments Select * From Inserted
 End
 GO

我收到一条错误消息:

'CREATE TRIGGER' must be the first statement in a query batch.

Answer 1

错误消息“'CREATE TRIGGER'必须是查询批中的第一个语句。”通常在前面的一组(批处理)语句没有终止 GO

时发生

因此，我建议在前一个批处理语句的末尾添加 GO。