阅读背景:

SQL Server触发器 - 使用deletetime将已删除的记录插入另一个表中

来源:互联网 

Currently I have a Item table and a ItemWaste table. Both tables will have some fields, such as: Name, Amount, etc. But the ItemWaste table will have one more field, which is the TimeWasted. I wish to automatically insert the DELETED item from the Item table to the ItemWaste table, and at the same time insert the deletion time to the TimeWasted field.Currently I have a Item table and a ItemWaste t




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: