标题: 请问怎么把oracle的触发器转换成sqlserver的触发器? [打印本页] 作者: 出场很重要 时间: 2020-8-16 20:00 标题: 请问怎么把oracle的触发器转换成sqlserver的触发器? CREATE OR REPLACE TRIGGER TRG_TEST5 AFTER INSERT or UPDATE ON test5 REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW DECLARE BEGIN IF tiaojian THEN DBMS_ALERT.SIGNAL('SIG_TEST5', MSGMSGMSG); END IF; NULL; EXCEPTION /* Unexptected Error */ WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE( 'Unexpected error is occured in trigger. SQLCODE:' || TO_CHAR(SQLCODE) ); DBMS_OUTPUT.PUT_LINE( SQLERRM ); END;作者: 出场很重要 时间: 2020-8-16 20:00
以上是oracle的触发器,怎么将他转换成sqlserver的?