mssql⾥关于触发器关键字for和after的区别

FOR and AFTER are the same type of triggers. FOR is deprecated and should not be used, use AFTER when defining a trigger.
功能都⼀致，都是在语句执⾏成功后触发的；For是之前sql server 版本中使⽤的语法关键字，已经逐步废弃了，以后都是⽤ after 关键字
了。
参考：
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2c903670-25d1-42aa-8759-3596943bbd86/sql-server-2008-what-is-the-
difference-between-forafter-definition-for-trigger