SQLServer触发器语法.pdf
版权申诉
140 浏览量
2021-10-08
17:47:48
上传
评论
收藏 312KB PDF 举报
SQL
触发器语法参考
CreateTRIGGER trigger_name
ON { table | view }
[ WITH ENCRYPTION ]
{
{ { FOR |AFTER | INSTEAD OF } { [ Insert ] [ , ] [ Updat
e ] }
[ 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 ]
}
}
剩余27页未读，继续阅读
资源评论
