sql触发器insert实例 SQL语句创建INSERT触发器?

SQL语句创建INSERT触发器?1.createtriggerinsertu banji ontu banji after insert as if(tnonotin(selecttnofromtu

SQL语句创建INSERT触发器?

1.createtriggerinsertu banji ontu banji after insert as if(tnonotin(selecttnofromtu banji))print “不go 2.createtriggerdeleteu banji ontu banji fordelete as if((selectcount(*)from tu banji,deleted where t_banji.tno=已删除.tno)0)删除wheretnoin(选择tnofromtu banji,删除wheret)_banji.tno=已删除(tno)走