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