日期:2014-05-17 浏览次数:20497 次
CREATE TRIGGER TRIGGER_A_INSERT ON A FOR INSERT AS BEGIN INSERT INTO C SELECT A.TYPECD FROM B INNER JOIN Inserted A ON A.TYPECD=B.TYPECD WHERE A.[VALUE] NOT BETWEEN B.VALUE1 AND B.VALUE2 END