chap04 存储过程 函数 触发器课件.pptx

第四章 存储过程 函数 触发器;存储过程;存储过程;嵌套存储过程;存储过程;用户定义函数;用户定义函数;用户定义函数;用户定义函数;用户定义函数;用户定义函数;用户定义函数;作为约束的函数;apply与表值函数;触发器;触发器;触发器;触发器;行级触发器;行级触发器;语句级触发器;before触发器;触发器：SQL Server;create trigger reminder_trigger on emp after delete as if @@rowcount = 0 return declare @msg varchar(100), @eno char(10), @ename char(10) declare cursorDeleted cursor for select eno, ename from deleted open cursorDeleted fetch next from cursorDeleted into @eno, @ename while @@fetch_status = 0 begin set @msg = 被删除的员工主码是: + @eno + 被删除的员工主码是: + @.ename print @msg fetch next from cursorDeleted into @eno, @ename end close cursorDeleted deallocate cursorDeleted;递归触发器;递归触发器;替代触发器;替代触发器;替代触发器;DDL触发器;DDL触发器;DDL触发器;DDL触发器;DDL触发器;DDL触发器;触发器的冲突;触发器的冲突;触发器计算过程;触发器计算过程; 把你的头靠向你的右肩 坚持10秒 我发现了！！！