修改DML触发器的语法格式-SQL_server_2008存储过程触发器
（1）修改DML触发器的语法格式： ALTER TRIGGER schema_name.trigger_name ON ( table | view ) [ WITH ENCRYPTION ] ( FOR | AFTER | INSTEAD OF ) { [ DELETE ] [ , ] [ INSERT ] [ , ] [ UPDATE ] } [ NOT FOR REPLICATION ] AS sql_statement [ ; ] [ ...n ] （2）修改DDL触发器的语法格式： ALTER TRIGGER trigger_name ON { DATABASE | ALL SERVER } [ WITH ENCRYPTION ] { FOR | AFTER } { event_type [ ,...n ] | event_group } AS sql_statement [ ; ]
文件大小：3.51MB
评论区