通过触发器进行的操作
摘要：
删除操作前，先备份一下--触发器生成CREATE trigger [detail_delete]on [dbo].[yy_detail]instead of delete --for deleteasbegininsert into bak_yy_detail select * from deleted --where id=@@identitydelete from yy_detail where id in(select id from deleted)endDeleted 表是用于存储 DELETE 和 UPDATE 语句所影响的行的复本的临时表，在执行 DELETE 或 UPDATE 阅读全文
posted @ 2014-02-19 09:00 来碗板面 阅读(174) 评论(0) 推荐(0) 编辑
