sql触发器insert实例 SQL语句创建INSERT触发器？
SQL语句创建INSERT触发器？1.createtriggerinsert_banji ont_banji afterinsert as if(tnonotin(selecttnofromt_ban
SQL语句创建INSERT触发器？
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