weixin_42835381的博客

一个简单触发器的结构 CREATE TRIGGER trigger_name ON table_name [WITH ENCRYPTION] FOR | AFTER | INSTEAD OF [DELETE, INSERT, UPDATE] AS T-SQL语句 GO 删除数据（联级） create trigger tri_test on StuInfo instead of delete as begin declare @id varchar(15) select @id=StuID from dele