CREATE TRIGGER trigdeletename1 ON [table1]
FOR DELETE
AS
declare @code integer
declare cur cursor for select code from deleted
open cur
fetch next from cur into @code
WHILE (@@FETCH_STATUS=0)
BEGIN
DELETE FROM Table2 WHERE code=@code
fetch next from cur into @code
END
CLOSE cur
DEALLOCATE cur
FOR DELETE
AS
declare @code integer
declare cur cursor for select code from deleted
open cur
fetch next from cur into @code
WHILE (@@FETCH_STATUS=0)
BEGIN
DELETE FROM Table2 WHERE code=@code
fetch next from cur into @code
END
CLOSE cur
DEALLOCATE cur
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货