需要帮助删除触发器 [英] Need help with delete trigger

问题描述

我想创建删除触发器。想法是当用户从表触发器中删除记录时将此记录移动到另一个表（此表是副本具有相同的字段，类型）但是这一切我想做dinamic。我这样开始：

I wanna create delete trigger. Idea is when user deletes the record from table trigger moves this record to another table (this table is copy has the same fields, types) But all this I want to do dinamic. I start so:

展开 | 选择 < span class =codeDivider> | Wrap | 行号

推荐答案

你的动态是什么意思？


您是否尝试动态传递tablename？

What do you mean by dynamic ?

Are you trying to pass tablename dynamically ?

动态是什么意思？


您是否尝试动态过去tablename？

What do you mean by dynamic ?

Are you trying to past tablename dynamically ?

是的。我生成字段设置@val = @val +''，[''+ @ fieldname +'']''

但也需要值，然后我会在查询中粘贴变量，如

set @q =''INSERT INTO my_table（''+ @ val +''）VALUES（这里我有问题，我无法从表中删除带字段@fieldname的值）''

Yes. I generated fields set @val = @val + '',[''+@fieldname + '']''
but also need values and then I will paste variables in the query like
set @q = ''INSERT INTO my_table (''+@val+'') VALUES (here I have problem, I cant get values from table Deleted with field @fieldname)''

现在我有

Now I have

展开 | 选择 | Wrap | 行号

这篇关于需要帮助删除触发器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！