[求助]存储过程编写求助！

狼书生

以下是引用tz-chf在2006-6-30 19:54:00的发言：
这样的表结构不好

要怎样结构才合理？

wuaza

试试触发器。

CREATE TRIGGER tri_a ON a
FOR INSERT,UPDATE,DELETE
AS
IF EXISTS (SELECT * FROM deleted)
BEGIN
DELETE FROM b WHERE .....--(所有栏位与deleted表相等的条件)
END
IF EXISTS (SELECT * FROM inserted)
BEGIN
INSERT INTO b SELECT * FROM inserted
END

狼书生

一言惊醒梦中人！真是太谢谢了！我马上去试下！

再次感谢！