SQL Server 2000 触发器

Question

使用 SQL Server 2000，我需要将一个表中删除的记录插入到第二个表中。

使用 SQL Server 2000 触发器实现此目的的最佳方法是什么？

感谢和问候

萨蒂亚

Answer 1

考虑这个删除触发器：

CREATE TRIGGER trig_delCustomer

ON Customer --the table being deleted from

FOR DELETE

AS

DECLARE @isOnContract BIT

--insert all the effected rows (the ones being deleted) into this other table.
INSERT INTO     
    MyOtherTable (ID, CustomerName, Email, Phone) 
SELECT 
    ID, [Name], Email, Phone
    FROM Deleted