SQL触发器语法参考-网友提供

昨天写了第一个触发器，今天在要研究触发器的语法

SQL触发器语法参考

 CreateTRIGGER trigger_name  ON { table | view }  [ WITH ENCRYPTION ]  {      { { FOR |AFTER | INSTEAD OF } { [ Insert ] [ , ] [ Update ] }        [ WITH APPEND ]        [ NOT FOR REPLICATION ]        AS        [ { IF Update ( column )            [ { AND | or } Update ( column ) ]                [ ...n ]        | IF ( COLUMNS_UpdateD ( ) { bitwise_operator } updated_bitmask)                { comparison_operator } column_bitmask [ ...n ]        } ]        sql_statement [ ...n ]      }  }    参数   trigger_name    是触发器的名称。触发器名称必须符合标识符规则，并且在数据库中必须唯一。可以选择是否指定触发器所有者名称。     Table | view

SQL触发器语法参考

 CreateTRIGGER trigger_name  ON { table | view }  [ WITH ENCRYPTION ]  {      { { FOR |AFTER | INSTEAD OF } { [ Insert ] [ , ] [ Update ] }