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