sql觸發(fā)器insert實(shí)例 SQL語(yǔ)句創(chuàng)建INSERT觸發(fā)器？
SQL語(yǔ)句創(chuàng)建INSERT觸發(fā)器？1.createtriggerinsert_banji ont_banji afterinsert as if(tnonotin(selecttnofromt_ban
SQL語(yǔ)句創(chuàng)建INSERT觸發(fā)器？
1.createtriggerinsert_banji ont_banji afterinsert as if(tnonotin(selecttnofromt_banji)) print"不能插入" go 2.createtriggerdelete_banji ont_banji fordelete as if((selectcount(*)fromt_banji，deleted wheret_banji.tno=deleted.tno)0) deletet_xs wheretnoin(selecttnofromt_banji，deleted wheret_banji.tno=deleted.tno) go