sql觸發(fā)器insert實例 SQL語句創(chuàng)建INSERT觸發(fā)器?
SQL語句創(chuàng)建INSERT觸發(fā)器?1.createtriggerinsertu banji ontu banji after insert as if(tnonotin(selecttnofromtu
SQL語句創(chuàng)建INSERT觸發(fā)器?
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)走