SQL SERVER触发器回顾(联级删除)
一个简单触发器的结构CREATE TRIGGER trigger_nameON table_name[WITH ENCRYPTION]FOR | AFTER | INSTEAD OF [DELETE,INSERT, UPDATE]AST-SQL语句GO删除数据(联级)create trigger tri_teston StuInfoinstead of deleteasbegindeclare @id varchar(15)select @id=StuID from dele
原创
2020-08-10 10:39:20 ·
646 阅读 ·
0 评论